PL/pgSQL support to define multi variables once

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: PL/pgSQL support to define multi variables once
Date: 2014-06-13 07:20:18
Message-ID: 539AA632.9070707@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
plpgsql_mvardef.patch text/x-patch 3.7 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2014-06-13 07:31:10 Re: pg_xlogdump --stats
Previous Message Michael Paquier 2014-06-13 07:20:05 Re: loading .so file at run time