2008/12/12 David E. Wheeler <da...@kineticode.com>: > 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? >
Personally I'm not keen on named parameter assignment, but if 'AS' is unpopular, and '=>' et al conflict with operators, would verilog-style syntax - eg function( .param(value) ) - be an idea? Ian -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers