RE: [GENERAL] Finding an empty field

SELECT * FROM TABLE WHERE FIELD1 = ''; or
SELECT * FROM TABLE WHERE FIELD1 IS NULL;

> -----Original Message-----
> From: ghoffman(at)ucsd(dot)edu [SMTP:ghoffman(at)ucsd(dot)edu]
> Sent: Tuesday, July 06, 1999 2:50 PM
> To: pgsql-general(at)postgreSQL(dot)org
> Subject: [GENERAL] Finding an empty field
>
> I'm having trouble finding empty fields so that I can fill them.
>
> This type of query seems to yield no returned rows:
>
> SELECT * FROM TABLE WHERE FIELD1 IS '';
> or
> UPDATE TABLE SET FIELD1 = 'SOMETHING' WHERE FIELD1 IS '';
>
>
> I've also fooled around with EMPTY and NOT EXISTS, but I can't get it
> right.
>
> What do you recommend to find empty fields?
>
> Thanks,
> Gary
>
> **************************************************************************
> * Gary B. Hoffman, Computing Services Manager e-mail: ghoffman(at)ucsd(dot)edu *
> * Graduate School of International Relations and Pacific Studies (IR/PS) *
> * University of California, San Diego (UCSD) voice: (619) 534-1989 *
> * 9500 Gilman Dr., La Jolla, CA 92093-0519 USA fax: (619) 534-3939 *
> **************************************************************************
>