| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Gregory Stark <stark(at)enterprisedb(dot)com>, Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Subject: | Re: WIP: default values for function parameters |
| Date: | 2008-12-12 12:50:37 |
| Message-ID: | A4D41CCA-5FCD-4597-BB5C-F5323F5D4400@kineticode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Dec 11, 2008, at 3:42 PM, Bruce Momjian wrote:
>> what do you thing about?
>>
>> select fce(p1,p2,p3, SET paramname1 = val, paramname2 = val)
>>
>> example
>> select dosome(10,20,30, SET flaga = true, flagb = false)
>
> I think AS read more naturally because you expect the parameter to
> come
> first, not the SET keyword.
Coming to this a bit late, but it seems to me that, while it makes
sense to assign a label to a value using "AS", it's kind of weird to
use it to assign a value to a label.
SELECT foo( bar => 'ick', baz => 'ack' );
SELECT foo( bar AS 'ick', baz AS 'ack' );
As a Perl hacker, I'm strongly biased toward =>, but I guess AS isn't
*too* bad. At least it's the same number of characters. Is -> right out?
Best,
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2008-12-12 12:55:18 | Re: SQL/MED compatible connection manager |
| Previous Message | Heikki Linnakangas | 2008-12-12 12:45:59 | Re: [Patch] Space reservation (pgupgrade) |