Howdy,
I'm sure most of you PostgreSQL users out there will be able to answer
this, but I'm just not finding the answer.
Let's say I have a table called project that has three fields:
field| type
---
id int
name varchar(30)
parent_id int
right now there is
> "RT" == "Rod Taylor" <[EMAIL PROTECTED]>:
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
