Pavel Stehule wrote: > 2008/12/10 Pavel Stehule <[EMAIL PROTECTED]>: > > 2008/12/10 Tom Lane <[EMAIL PROTECTED]>: > >> "Pavel Stehule" <[EMAIL PROTECTED]> writes: > >>> next argument - if we accept AS for param names, then we introduce > >>> nonconsistent behave with SQL/XML functions. > >> > >>> select xmlforest(c1, c2 as foo, c3) -- there foo isn't doesn't mean > >>> "use it as param foo", > >> > >> It could be read as meaning that, I think. > >> > >> In any case, I'm not wedded to using AS for this, and am happy to > >> consider other suggestions. > > 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. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
