Peter Eisentraut Wrote:
> If I read this right, SQL would allow writing
>
> TABLE foo;
Interesting; I managed to find it in the spec:
<Quote>
4) The <explicit table>
TABLE <table or query name>
is equivalent to the <table subquery>
( SELECT * FROM <table or query name> )
</Quote>
So going by that would the patch also have to support something like:
WITH a AS (SELECT * FROM b)
TABLE a; ?
I'd probably find it hard to find a use case. I'm too used to using SELECT *
FROM .. in psql. On the other hand last night I read a good web page
comparing the most popular RDBMS' for spec. compliance and PostgreSQL
probably was the most compliant all of the ones listed, (at least on the
topics covered). Oracle fails badly on '' IS NULL being true.
I enjoy seeing more spec compliant things being added. But on the other
hand, going with Tom's comments, if its lots of work for little gain...
