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

From Ian Barwick
Subject Re: PL/pgSQL support to define multi variables once
Date
Msg-id 539AAB5D.4090607@2ndquadrant.com
Whole thread Raw
In response to PL/pgSQL support to define multi variables once  (Quan Zongliang <quanzongliang@gmail.com>)
Responses Re: PL/pgSQL support to define multi variables once  (Quan Zongliang <quanzongliang@gmail.com>)
List pgsql-hackers
Hi

On 14/06/13 16:20, Quan Zongliang wrote:
> Hi all,
> 
> Please find the attachment.
> 
> 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;

Please submit this patch to the current commitfest:
 https://commitfest.postgresql.org/action/commitfest_view?id=22


Regards

Ian Barwick


-- Ian Barwick                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Use unique index for longer pathkeys.
Next
From: Pavel Stehule
Date:
Subject: Re: PL/pgSQL support to define multi variables once