Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows)

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