On 29/04/2014 12:54, David Noel wrote:
'health'<>'' (if that is what you have) means a boolean expression that
compares the
literal 'health' with the empty literal '' which is of course always false.
Ah. Gotcha. Thanks. I didn't know you could use a single double
quotation mark in a query -- I thought like in most languages that you
needed two of them for it to be valid.
But there are two of them : ' and ' makes ''. If you use only one psql/parser will complain.
Maybe *health* is a column name somewhere ? In this case it should be
written :
"health" <> '' (i.e. comparison between the value of column "health" and the
literal value '')
'health' is one of the accepted values of the page table's
"Classification" column.
Many thanks,
-David
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
