> On that note I do have vague intentions of compiling a list
> of PostgreSQL gotchas. The only other one I have right now is
> PostgreSQL's mandatory AS as in
> SELECT col AS whatever
> instead of the alternative
> SELECT col whatever
>
> which IIRC is standard-compliant (there is a thread on this
> somewhere).
I believe in the spec AS is optional. Peter had a proposal for allowing
optional AS in PostgreSQL, but I don't remember why it wasn't
implemented.