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
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