Fields of postgres type "Time zone with time zone" are excluded from query result set
Original Reporter info from Mantis: dgaspary @dgaspary
-
Reporter name: Daniel Gaspary
Original Reporter info from Mantis: dgaspary @dgaspary
- Reporter name: Daniel Gaspary
Description:
As the example shows, the fields of this type are omitted.
No error messages.
Environment:
------------
FPC: 2.4.2-0 [2010/11/20] for x86_64
Ubuntu 10.10 x866_64
Postgres 8.3 - ENCODING = 'UTF8'
Additional information:
Workaround:
-Typecast to timestamp:
SELECT CAST(tsz AS timestamp) FROM testfpc;