Re: PL/pgSQL support to define multi variables once - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: PL/pgSQL support to define multi variables once
Date
Msg-id CAB7nPqQ-SSK6n8efOt6tmZn=zX8DvbmqWed+5sWVchwbaKBaLg@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL support to define multi variables once  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
On Fri, Jun 13, 2014 at 4:43 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
>
>
>
> 2014-06-13 9:41 GMT+02:00 Michael Paquier <michael.paquier@gmail.com>:
>
>> On Fri, Jun 13, 2014 at 4:20 PM, Quan Zongliang <quanzongliang@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 :)
Sorry I misread his email.
-- 
Michael



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Few observations in replication slots related code
Next
From: Abhijit Menon-Sen
Date:
Subject: [PATCH] introduce XLogLockBlockRangeForCleanup()