looking for empty fields
От | Jodi Kanter |
---|---|
Тема | looking for empty fields |
Дата | |
Msg-id | 3F310BA1.2010701@virginia.edu обсуждение исходный текст |
Список | 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 variouslocations looking for nulls and/or empty fields. To search for empty fields we said something like <br /><br /> selectcount(am_pk) from arraymeasurement where al_fk is null or al_fk='';<br /><br /> Is this not allowed anymore? All mycheck with the double ticks are failing. I assume there is a difference in postgres between an empty and null field. Howcan I check for both in 7.3.3?<br /> Thanks<br /> Jodi<br /><div class="moz-signature">-- <br /></div><div class="Section1"><pclass="MsoNormal"><i><span style="font-size: 9pt; font-family: Arial; "> _______________________________<br/></span></i><i><span style="font-size: 10pt; ">Jodi L Kanter<br /> BioInformatics DatabaseAdministrator<br /> University of Virginia<br /> (434) 924-2846<br /><a href="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a></span></i><span style="font-size: 11pt; font-family: Arial; "><brstyle="mso-special-character:line-break" /><br style="mso-special-character:line-break" /></span><p class="MsoNormal"><spanstyle="font-size: 11pt; font-family: Arial; "> </span><p class="MsoNormal"><i><span style="font-size:9pt; font-family: Arial; "> </span></i><p class="MsoNormal"><i><span style="font-size: 9pt; font-family:Arial; "> </span></i></div>
В списке pgsql-sql по дате отправления: