Re: Patch: Allow SQL-language functions to reference parameters by parameter name
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matthew Draper <matthew@trebex.net>
Cc: Hitoshi Harada <umi.tanuki@gmail.com>, pgsql-hackers@postgresql.org
Date: 2012-02-05T00:30:35Z
Lists: pgsql-hackers
Matthew Draper <matthew@trebex.net> writes: > [ sql-named-param-refs-v2.patch ] Applied with some editorialization: I switched the behavior for two-part names as discussed, and did some other mostly-cosmetic code cleanup, and did some work on the documentation. > I'm still not sure whether to just revise (almost) all the SQL function > examples to use parameter names, and declare them the "right" choice; as > it's currently written, named parameters still seem rather second-class. They're less second-class in the docs as committed, but I left a lot of examples still using $n for parameters. I'm not sure how far to go in that direction. We should not be too eager to scrub the docs of $n, because if nothing else people will need to understand the notation when they see it for a long time to come. But feel free to submit a follow-up docs patch if you feel more is warranted. regards, tom lane