PL/pgSQL support to define multi variables once
От
Quan Zongliang
Тема
PL/pgSQL support to define multi variables once
Дата
Msg-id
539AA632.9070707@gmail.com
Список
Дерево обсуждения
PL/pgSQL support to define multi variables once Quan Zongliang <quanzongliang@gmail.com>
Re: PL/pgSQL support to define multi variables once Alvaro Herrera <alvherre@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 Pavel Stehule <pavel.stehule@gmail.com>
Re: PL/pgSQL support to define multi variables once Andres Freund <andres@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 David G Johnston <david.g.johnston@gmail.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 Pavel Stehule <pavel.stehule@gmail.com>
Re: PL/pgSQL support to define multi variables once David Johnston <david.g.johnston@gmail.com>
Re: PL/pgSQL support to define multi variables once Robert Haas <robertmhaas@gmail.com>
Re: PL/pgSQL support to define multi variables once Pavel Stehule <pavel.stehule@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 Quan Zongliang <quanzongliang@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 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 Pavel Stehule <pavel.stehule@gmail.com>
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
В списке pgsql-hackers по дате отправления