>>> On Tue, Dec 19, 2006 at 9:23 AM, in message
<24047.1166541794@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> It's easy to see how it resolves the column references; but the
syntax
>> is still not compliant with the SQL standard. The FROM clause is
>> required. We could call it a PostgreSQL extension, but I'm curious
if
>> anyone actually finds it useful.
>
> You've never done "SELECT some_expression" ?
Not, as far as I can recall, in the ANSI SQL spec. Did I miss
something?
I'm having trouble seeing how it is a useful construct in the context
of a scalar subquery. A non-standard extension should be useful in some
way.
-Kevin