> '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. > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
