From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | Quan Zongliang <quanzongliang(at)gmail(dot)com>, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PL/pgSQL support to define multi variables once |
Date: | 2014-06-13 07:43:27 |
Message-ID: | CAFj8pRCi4jeQ9fowYyk6E=eDiBKarmv5tytRvv8DnM5AbuHFoA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2014-06-13 9:41 GMT+02:00 Michael Paquier <michael(dot)paquier(at)gmail(dot)com>:
> On Fri, Jun 13, 2014 at 4:20 PM, Quan Zongliang <quanzongliang(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2014-06-13 07:48:06 | Re: WAL replay bugs |
Previous Message | Ian Barwick | 2014-06-13 07:42:21 | Re: PL/pgSQL support to define multi variables once |