| From: | Dan Weeks <danimal(at)wildbrain(dot)com> |
|---|---|
| To: | Rod Taylor <rbt(at)rbt(dot)ca> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: silly NULL question |
| Date: | 2003-07-24 23:31:13 |
| Message-ID: | 16160.27713.892311.733277@underdog.wildbrain.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>>>>> "RT" == "Rod Taylor" <rbt(at)rbt(dot)ca>:
RT> NULL is similar to UNKNOWN.
RT>
RT> So, NULL = NULL is the similar to UNKNOWN = UNKNOWN. Since you don't
RT> know it, how can you tell if they're equal or not?
RT>
RT> Syntax you're looking for is: AND parent_id IS NULL
ah, of course. Thanks Rod.
RT> If you really really really need = NULL (due to some MS product which
RT> ignores SQL standards -- say MS Access) there is a toggle in the
RT> postgresql.conf file to allow automated conversion of = NULL to IS NULL
RT> within the server.
ah ha! the culprit. I see this was default through 7.1. Thanks again for
accurate and quick reply.
-dan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vijaykumar M | 2003-07-25 06:04:55 | Equivalent to sql%rowcount or @@rowcount |
| Previous Message | Rod Taylor | 2003-07-24 23:25:16 | Re: silly NULL question |