2014-06-13 9:41 GMT+02:00 Michael Paquier <michael.paqu...@gmail.com>:
> On Fri, Jun 13, 2014 at 4:20 PM, Quan Zongliang <quanzongli...@gmail.com> > wrote: > > By my friend asking, for convenience, > > support to define multi variables in single PL/pgSQL line. > > > > Like this: > > > > CREATE OR REPLACE FUNCTION try_mutlivardef() RETURNS text AS $$ > > DECLARE > > local_a, local_b, local_c text := 'a1----'; > > BEGIN > > return local_a || local_b || local_c; > > end; > > $$ LANGUAGE plpgsql; > I don't recall that this is possible. Have a look at the docs as well: > http://www.postgresql.org/docs/current/static/plpgsql-declarations.html > -- > It will be possible with Quan' patch :) Pavel > Michael > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
