> This is one of the many SQL bad habits you've likely picked up from
> using MySQL. I'd highly suggest reading the pgsql users manual cover
> to cover, you'll pick up a lot of good info on how to drive
> postgresql. Other things that work in mysql but fail in pgsql include
> inserting things that are out of range.
You know, I bet as many of us came to PostgreSQL from a MySQL background
as from Oracle. It might be good to have a section in the manual for how
to transition from using the "tricks" in MySQL to a strict environment
like Postgres.