| From: | Jodi Kanter <jkanter(at)virginia(dot)edu> |
|---|---|
| To: | Postgres SQL List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | looking for empty fields |
| Date: | 2003-08-06 14:07:29 |
| Message-ID: | 3F310BA1.2010701@virginia.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
We recently upgraded from version 7.2.3 to 7.3.3 and seem to have some
code that has broken. We were doing checks in various locations looking
for nulls and/or empty fields. To search for empty fields we said
something like
select count(am_pk) from arraymeasurement where al_fk is null or al_fk='';
Is this not allowed anymore? All my check with the double ticks are
failing. I assume there is a difference in postgres between an empty and
null field. How can I check for both in 7.3.3?
Thanks
Jodi
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter(at)virginia(dot)edu <mailto:jkanter(at)virginia(dot)edu>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kurt Overberg | 2003-08-06 14:18:55 | Re: [SQL] JDBC encoding problem |
| Previous Message | Viorel Dragomir | 2003-08-06 14:02:02 | Re: looking for empty fields |