Postgres SQL operator does not exist; character = integer;

Question

I am do replicating of two database (SQL Server 2000 and PostgreSQL). I use http://blog.hagander.net/archives/103-Replicating-from-MS-SQL-Server-to-PostgreSQL.html for this. Then I do last step the

ERROR: operator does not exist: character = integer; Error executing the query

appeared. I use the PostgreSQL 8.4.6 for that and ODBC drivers (all psqlodbc_08_04_0100.zip, psqlodbc_08_04_0200.zip) from here i also try to delete and install version that Synaptic called 9.0.2-1 and update odbc drivers i try (psqlodbc_09_00_0100.zip, psqlodbc_09_00_0101.zip, psqlodbc_09_00_0200.zip) it also return that error. The query launched from delphi where i use only System DSN runs normally

Please show us the executed and failing query from the postgresql logfile. I believe this is a setting in the PostgreSQL ODBC driver, but to debug this, I need the exact query done. — Daniel
– Daniel, Commented Feb 1, 2011 at 15:05

user330315 · Accepted Answer · 2011-02-01 10:50:51Z

6

You need to fix your SQL statement.

I bet you have something like

WHERE character_column = 1

and you need to change that to

WHERE character_column = '1'

answered Feb 1, 2011 at 10:50

user330315

Sign up to request clarification or add additional context in comments.

Comments

Lucas Gervas · Accepted Answer · 2017-05-01 12:25:20Z

0

use single quote 'your_value' for non numeric data and double quote for column name and never the opposite.

select status, sum(amount) as sum from "sales" where ("date" <= '2017-04-30 23:59:59' and "customer_id" = 1) and "sales"."deleted_at" is null group by "status"

answered May 1, 2017 at 12:25

Lucas Gervas

3792 silver badges5 bronze badges

Collectives™ on Stack Overflow

Postgres SQL operator does not exist; character = integer;

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related