Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 65AEF1337B49
	for <pgsql-novice-postgresql.org@mail.postgresql.org>;
	Tue,  3 May 2011 07:20:59 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 08419-01; Tue,  3 May 2011 10:20:49 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com
	[209.85.220.174])
	by mail.postgresql.org (Postfix) with ESMTP id CE38D1337A5D;
	Tue,  3 May 2011 07:20:47 -0300 (ADT)
Received: by vxi39 with SMTP id 39so4885246vxi.19
	for <multiple recipients>; Tue, 03 May 2011 03:20:47 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:cc:content-type;
	bh=wjCLZvJxxxB36oFYQl5WzU5fVfhC3uCoM55RjUpAnSA=;
	b=TTYigHmwIkaZGHJPbvuNqoNx9i36EWHmmscs+ZuNv+hByOJH4ak1hOZo3Y9MggfZiq
	7J7LLG/XZBeY0m0NnEeOwi9vy0da2h4e0l1QZhOcaCcgB0SuetJYbrTsJ8VruijmnqIo
	0JGHJFmAyMNqx66efwfkUx4UbPK7hA9AMnkn8=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=c2WK6ltnHz3pxHgg+mP3TW1ZZUnQnJ5diOofGToY/fx0qPzoFgZoZ/BCVBfhb0Hi9Y
	mZHtPNVg+4Y6TSi5adxJaG+0vIIdPTqmV59bJtnvRCCrVHC0btL8165/aew93XxQbQQj
	9wskqHEei1K/wuIy4Ljm66EjXIp/gR1gzxYVA=
MIME-Version: 1.0
Received: by 10.52.97.10 with SMTP id dw10mr1240307vdb.23.1304418047595; Tue,
	03 May 2011 03:20:47 -0700 (PDT)
Received: by 10.52.182.4 with HTTP; Tue, 3 May 2011 03:20:47 -0700 (PDT)
In-Reply-To: <BANLkTiknnDKvskyOzCOX19zLQeKTc8Agvg@mail.gmail.com>
References: <379871.77718.qm@web161612.mail.bf1.yahoo.com>
	<BANLkTiknnDKvskyOzCOX19zLQeKTc8Agvg@mail.gmail.com>
Date: Tue, 3 May 2011 12:20:47 +0200
Message-ID: <BANLkTimuzqbOW3Rm+c-iWw4AoPvOz=W8YA@mail.gmail.com>
Subject: Re: [SQL] PLpgSQL variables persistance between several functions
	calls
From: Willy-Bas Loos <willybas@gmail.com>
To: "Charles N. Charotti" <ccharotti@yahoo.com>
Cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org,
	Pavel Stehule <pavel.stehule@gmail.com>
Content-Type: multipart/alternative; boundary=20cf307d01ee5d96f504a25c7e3c
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.897 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RFC_ABUSE_POST=0.001
X-Spam-Level: 
X-Archive-Number: 201105/11
X-Sequence-Number: 25021

--20cf307d01ee5d96f504a25c7e3c
Content-Type: text/plain; charset=ISO-8859-1

Hi,
Maybe calling a function from within another function would be a solution to
you.

Cheers,

WBL

On Tue, May 3, 2011 at 4:10 AM, Pavel Stehule <pavel.stehule@gmail.com>wrote:

> Hello
>
> no, it's not possible
>
> Regards
>
> Pavel Stehule
>
> 2011/5/2 Charles N. Charotti <ccharotti@yahoo.com>:
> > Hello everybody !
> >
> > I want to know if I could share PLpgSQL variables between different
> > functions and within different calls just using memory (not tables or
> other
> > methods).
> >
> > If it is really possible ?
> >
> > Thanks in advance,
> >
> > Chuck
> >
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>



-- 
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw

--20cf307d01ee5d96f504a25c7e3c
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<div>Maybe calling a function from within another function would be a so=
lution to you.</div><div><br><div>Cheers,</div><div><br></div><div>WBL</div=
><div><br><div class=3D"gmail_quote">On Tue, May 3, 2011 at 4:10 AM, Pavel =
Stehule <span dir=3D"ltr">&lt;<a href=3D"mailto:pavel.stehule@gmail.com">pa=
vel.stehule@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex;">Hello<br>
<br>
no, it&#39;s not possible<br>
<br>
Regards<br>
<br>
Pavel Stehule<br>
<br>
2011/5/2 Charles N. Charotti &lt;<a href=3D"mailto:ccharotti@yahoo.com">cch=
arotti@yahoo.com</a>&gt;:<br>
<div><div></div><div class=3D"h5">&gt; Hello everybody !<br>
&gt;<br>
&gt; I want to know if I could share PLpgSQL variables between different<br=
>
&gt; functions and within different calls just using memory (not tables or =
other<br>
&gt; methods).<br>
&gt;<br>
&gt; If it is really possible ?<br>
&gt;<br>
&gt; Thanks in advance,<br>
&gt;<br>
&gt; Chuck<br>
&gt;<br>
<br>
</div></div><font color=3D"#888888">--<br>
Sent via pgsql-sql mailing list (<a href=3D"mailto:pgsql-sql@postgresql.org=
">pgsql-sql@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-sql" target=3D"_blank">=
http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>&quot;Patriotism=
 is the conviction that your country is superior to all others because you =
were born in it.&quot; -- George Bernard Shaw<br>
</div></div>

--20cf307d01ee5d96f504a25c7e3c--