On Sat, Mar 7, 2009 at 9:08 AM, Rod Taylor <rod.tay...@gmail.com> wrote: > It wouldn't be so bad if you could assign internal and external column names. > > Within the function you call the column "v_foo" but the caller of the > function receives column "foo" instead. > > OUT v_foo varchar AS "foo" > > > Another alternative is requiring a prefix like plout for the > replacement to occur: > > ( OUT foo varchar ) > > BEGIN > SELECT foo.somename INTO plout.foo FROM foo WHERE id = 10; > > RETURN NEXT; > > RETURN; > END;
This is a good point. Uglifying the parameter names is sort of OK for input parameters, but is much more annoying for output parameters. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
