Re: [SQL] Differentiate Between Zero-Length String and NULLColumn Values

2007-02-05 Thread BillR
Peter Eisentraut wrote: D'Arcy J.M. Cain wrote: SELECT * FROM table WHERE column IS NULL; SELECT * FROM table WHERE column = NULL; The latter violates the SQL spec and is not allowed by PostgreSQL without setting a special flag. It doesn't violate any spec and it's certainly a

[SQL] domains and serial

2006-12-29 Thread BillR
Is it not possible to set up a domain using this construct? I will have a lot of tables using integer and big integer types as primary key identifier fields. It would make things simpler if I can use the serial construct in a domain instead of using an int or bigint in the domain, and then ch