Re: Note on scalar subquery syntax - Mailing list pgsql-general

From Kevin Murphy
Subject Re: Note on scalar subquery syntax
Date
Msg-id 42F10FC2.6090801@genome.chop.edu
Whole thread Raw
In response to Re: Note on scalar subquery syntax  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Martijn van Oosterhout wrote:

>On Wed, Aug 03, 2005 at 09:40:26AM -0400, Kevin Murphy wrote:
>
>
>>You have to wrap a scalar subquery in its own parentheses even where you
>>might think it to be unnecessary, such as when the subquery is the sole
>>argument to a function.
>>
>>
>
>It first guess I imagine it is because the syntax becomes ambiguous,
>expecially if you have multiple arguments to the function.
>
>
Thanks, Martijn.  Yes, I don't consider it to be entirely unreasonable;
it was just surprising and strange-looking to me.

-Kevin


pgsql-general by date:

Previous
From: Kevin Murphy
Date:
Subject: Re: Note on scalar subquery syntax
Next
From: Tom Lane
Date:
Subject: Re: Note on scalar subquery syntax