>>> On Tue, Dec 19, 2006 at 9:23 AM, in message
<24047(dot)1166541794(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)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