> "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
> Would return the row. Now with an upgrade to PostgreSQL 7.3 (yes, I know
> there are many changes and we're working through them right now) the same
> query returns nothing. Dropping the "AND parent_id = NULL" returns the row
> as expected.
NULL is similar to UNKNOWN.
So, NULL = NULL is the s
