From: | Postgres DBA <postgres(at)nest(dot)bistbn(dot)com> |
---|---|
To: | darold <darold(at)neptune(dot)fr> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] PB with Null string |
Date: | 1998-12-23 09:37:21 |
Message-ID: | Pine.BSF.4.02.9812231137160.19908-100000@nest.bistbn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Instead you should use "IS NOT NULL" or "IS NULL":
SELECT * FROM t_table WHERE s_string IS NULL;
Aleksey
On Wed, 23 Dec 1998, darold wrote:
> Hi,
>
>
> I have tried this query to check if a field is empty:
>
> SELECT * FROM t_table WHERE s_string='';
>
> where s_string is declared as text. But this doesn't work, why? Is
> there's an
> other way to do that ? I have also tried with NULL but I think it is not
> included
> in the 6.3.2...
>
> Thank,
>
> Gilles
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-12-23 09:37:44 | Re: [GENERAL] PB with Null string |
Previous Message | darold | 1998-12-23 09:33:24 | Backup of large object |
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1998-12-23 09:37:44 | Re: [GENERAL] PB with Null string |
Previous Message | darold | 1998-12-23 09:26:33 | PB with Null string |