agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedSearching for empty String.
3+ messages / 3 participants
[nested] [flat]
* Searching for empty String.
@ 1994-05-05 23:49 Michael Reifenberger <root@rz-wb.fh-sw.de>
1994-05-06 00:19 ` Re: Searching for empty String. Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Reifenberger @ 1994-05-05 23:49 UTC (permalink / raw)
To: legacy
Hi. My first question to the list is:
How can I retrieve for empty strings.
After creating:
create C (num=int4, name=text)
and after reading in from a file I have:
spog > retrieve (C.all)
124 (null)
2234 gfgfg
22 (null)
Ok, so far, so good.
Now if I do:
retrieve (C.all) where C.name = ""
I get no results but from my understanding it should be:
124 (null)
22 (null)
Is this a bug or feature?
Is the any way to retrieve empty (null) fields?
Bye!
....
Michael Reifenberger
===============================================================================
To add/remove yourself from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
===============================================================================
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Searching for empty String.
1994-05-05 23:49 Searching for empty String. Michael Reifenberger <root@rz-wb.fh-sw.de>
@ 1994-05-06 00:19 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
0 siblings, 0 replies; 3+ messages in thread
From: Paul M. Aoki @ 1994-05-06 00:19 UTC (permalink / raw)
To: Michael Reifenberger <root@rz-wb.fh-sw.de>; +Cc: legacy
Michael Reifenberger <root@rz-wb.fh-sw.de> writes:
> Is the any way to retrieve empty (null) fields?
null is not the same as an empty string.
if your fields contain zero-length strings, the query you gave (where
foo.bar = "") will retrieve them.
if your fields contain null, you should use the ISNULL and NOTNULL
keywords as documented in the manual.
--
Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU
| Berkeley, CA 94720 | ...!uunet!ucbvax!aoki
===============================================================================
To add/remove yourself from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
===============================================================================
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Searching for empty String.
@ 1994-05-06 01:15 ahmed@SDSC.EDU
0 siblings, 0 replies; 3+ messages in thread
From: ahmed@SDSC.EDU @ 1994-05-06 01:15 UTC (permalink / raw)
To: legacy; root@rz-wb.fh-sw.de
===============================================================================
To add/remove yourself from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
===============================================================================
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1994-05-06 01:15 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1994-05-05 23:49 Searching for empty String. Michael Reifenberger <root@rz-wb.fh-sw.de>
1994-05-06 00:19 ` Paul M. Aoki <aoki@postgres.Berkeley.EDU>
1994-05-06 01:15 Re: Searching for empty String. ahmed@SDSC.EDU
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox