I've got strange error with query
syntax error at or near ":"select "field"::integer from "table"
type of "field" is boolean
what can it be?
Moderators: gto, cipto_kh, EgonHugeist
syntax error at or near ":"select "field"::integer from "table"
Code: Select all
SELECT CASE WHEN "field" THEN 1 ELSE 0 END FROM "table";
Code: Select all
SELECT CAST("field" as integer) FROM "table";
Code: Select all
SELECT CAST("field" as integer) as "FieldName" From "table";