From: | nzanella(at)cs(dot)mun(dot)ca (Neil Zanella) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | AS operator and subselect result names: PostgreSQL vs. Oracle |
Date: | 2003-11-01 04:44:19 |
Message-ID: | b68d2f19.0310312044.3c98da8d@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I would like to ask the about the following...
PostgreSQL allows tables resulting from subselects to be renamed with
an optional AS keyword whereas Oracle 9 will report an error whenever
a table is renamed with the AS keyword. Furthermore, in PostgreSQL
when the result of a subselect is referenced in an outer select
it is required that the subselect result be named, whereas this
is not true in Oracle. I wonder what standard SQL has to say
about these two issues. In particular:
1. Does standard SQL allow an optional AS keyword for (re/)naming
tables including those resulting from subselects.
and
2 Why must a subselect whose fields are referenced in an outer query
be explicitly named in PostgreSQL when it is not necessary in Oracle.
Thanks,
Neil
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-11-01 04:56:56 | Re: 7.3.5 release (was: Re: SELECT with row>32k hangs over |
Previous Message | Ryan Mack | 2003-11-01 01:36:21 | PostgreSQL License Question |