2009/5/20 Steve Prentice <prent...@cisco.com>: > t := fun1(1 as a); -- syntax error: "SELECT fun1(1 as $1 )" > > t := fun1(a as a); -- syntax error: "SELECT fun1( $1 as $1 )" > > On May 19, 2009, at 6:42 PM, Merlin Moncure wrote: > > you have a name conflict here...is it deliberate? I've learned the > hard way to always, always prefix arguments and locals to plpgsql > functions with '_'. Or are you trying to do something fancier? > > The conflict is deliberate to illustrate the limitations the named parameter > feature (on the list for the first 8.5 CommitFest) is going to have if > parameter substitution is not addressed at the same time. > -Steve
this problem is little bit deeper and is related to plpgsql method for SQL query processing. I thing so there are two solutions: a) use dynamic SQL b) use double quotes for identifier - identifiers have to be lower t := fun1(a as "a"); regards Pavel Stehule -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers