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

From Quan Zongliang
Subject PL/pgSQL support to define multi variables once
Date
Msg-id 539AA632.9070707@gmail.com
Whole thread Raw
Responses Re: PL/pgSQL support to define multi variables once  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: PL/pgSQL support to define multi variables once  (Michael Paquier <michael.paquier@gmail.com>)
Re: PL/pgSQL support to define multi variables once  (Ian Barwick <ian@2ndquadrant.com>)
Re: PL/pgSQL support to define multi variables once  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PL/pgSQL support to define multi variables once  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
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;


Regards,
Quan Zongliang


---
此电子邮件没有病毒和恶意软件,因为 avast! 防病毒保护处于活动状态。
http://www.avast.com

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: loading .so file at run time
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: pg_xlogdump --stats