Search Postgresql Archives

real - integer type cast in prepared statements

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi!

Why when I prepare statement by parsing such query: 'SELECT * FROM "test" WHERE "ind" < $1 + 1' ("ind" is of type REAL) $1 is interpreted by backend as INTEGER? Parse completed successfully, but trying to bind parameter as '20.20' resulted in "ERROR C22P02 Minvalid input syntax for integer: "20.20" Fnumutils.c L98 Rpg_atoi"? I understand that it's possible to make query like 'SELECT * FROM "test" WHERE "ind" < $1::real + 1', but at the query building time I can't know what type this column is!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux