From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | David(dot)I(dot)Noel(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows) |
Date: | 2014-04-29 09:58:37 |
Message-ID: | 535F77CD.9050502@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2014-04-29 10:00:26 | Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows) |
Previous Message | David Noel | 2014-04-29 09:54:14 | Re: SQL query runs fine on one platform (FreeBSD), but hangs on another (Windows) |