zeos & postgresql

[folibis]

I use ZEOS component in Builder C++ with PostgreSQL 8.2
I've got strange error with query

select "field"::integer from "table"

syntax error at or near ":"

type of "field" is boolean
what can it be?

[folibis]

ok ... I resolve the problem.
It must by "field"::::integer from any reason.
But now query return value "False" without conversion.
I need integer value ....

[btrewern]

You could use:

Code: Select all

SELECT CASE WHEN "field" THEN 1 ELSE 0 END FROM "table";

You can also try

Code: Select all

SELECT CAST("field" as integer) FROM "table";

Regards,

Ben

[folibis]

both CAST and ::integer returns "False" in this query
I don't know what the reason ...

But CASE is good idea ... I guess i take it thanks

[btrewern]

If you try

Code: Select all

SELECT CAST("field" as integer) as "FieldName" From "table";

It may work.

Looks like this is to do with the slightly brain dead way Zeos finds the type of columns.

Regards,

Ben