Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Notifications
Clear all
Topic starter
Postgresql data types are strict. So a numeric type can only accept literal numbers. This means a numeric will accept 1 but not '1' since the latter is a character or string type. Moreover it is incorrect to use a numeric type (1,0) when a boolean is the real intention. The boolean can accept:
TRUE
't'
'true'
'y'
'yes'
'on'
'1'
For the "false" state, the following values can be used:
FALSE
'f'
'false'
'n'
'no'
'off'
'0'
http://www.postgresql.org/docs/9.4/static/datatype-boolean.html
Posted : 08 Oct 2015 15H28
and ?
Posted : 09 Oct 2015 11H12