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 -- Michael
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers