>>> On Tue, Dec 19, 2006 at 9:23 AM, in message <[EMAIL PROTECTED]>, Tom Lane <[EMAIL PROTECTED]> wrote: > "Kevin Grittner" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings