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@ucsd.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 *
**************************************************************************
SELECT * FROM TABLE WHERE FIELD1 = ''; or
SELECT * FROM TABLE WHERE FIELD1 IS NULL;
Show quoted text
-----Original Message-----
From: ghoffman@ucsd.edu [SMTP:ghoffman@ucsd.edu]
Sent: Tuesday, July 06, 1999 2:50 PM
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] Finding an empty fieldI'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@ucsd.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 *
**************************************************************************
Import Notes
Resolved by subject fallback