On Wednesday 22 September 2010 5:12:45 pm TJ O'Donnell wrote: > Many frameworks do not natively recognize "t" as true and "f" as false. > I'm using php, json_encode and extjs. > Is it possible to cause the default output of boolean values to be > something other than "t" and "f", say "true" and "false" or even 1 and 0? > Of course I can do this for an individual query using appropriate > functions, but it would help me to be able to modify the default behavior. > > TJ >From here; http://www.postgresql.org/docs/8.4/interactive/datatype-boolean.html Valid literal values for the "true" state are: TRUE 't' 'true' 'y' 'yes' 'on' '1' For the "false" state, the following values can be used: FALSE 'f' 'false' 'n' 'no' 'off' '0' -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general