| From: | Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Note on scalar subquery syntax |
| Date: | 2005-08-03 18:41:06 |
| Message-ID: | 42F10FC2.6090801@genome.chop.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Magnus Hagander | 2005-08-03 19:07:05 | Re: Windows file path for copy |
| Previous Message | Kevin Murphy | 2005-08-03 18:38:27 | Re: Note on scalar subquery syntax |