Hello everybody !

I want to know if I could share = PLpgSQL variables between different functions and within different calls ju= st using memory (not tables or other methods).

If it is really possi= ble ?

Thanks in advance,

Chuck

=0A=0A=0A=0A

--0-1410404537-1304372611=:77718-- From pavel.stehule@gmail.com Tue May 3 02:10:57 2011 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id E57DB1337B3E for ; Mon, 2 May 2011 23:10:57 -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 10640-01; Tue, 3 May 2011 02:10:52 +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-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id D4B6A133798E; Mon, 2 May 2011 23:10:49 -0300 (ADT) Received: by iyb14 with SMTP id 14so5119215iyb.19 for ; Mon, 02 May 2011 19:10:50 -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:from:date :message-id:subject:to:cc:content-type; bh=d+jEz6eHCf9isAt4GiIBIJOABGMNNz5bwWn3ukF8y5Y=; b=mY/YPSUgjhToutXB05mIwxrx6hCuUUdynejy66wEOw4TwoLUKhRdYNnH1dg+z4J9YG WtU0E5vn/ACMK60pxx7oo6cLpwmXInpGCgOQmwVTBWEUvwyp411O1mhT+52SS1zumYkj HR8JnOZVKVV7MWBlMa7czGfLPwMLgKUYl/9BE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type; b=JyYcr1HdCRqznIDnzr4oZOwHWa9/u+6cxAW3vp2cpN8goO96kM3msbr2N+2IRcGXbw NEJ9rjMSDq+gSZR5dTFZbKcf3IELgKpwUQNIu5RBD9ERMn+NBcw+Bg3JXtHL0aq+vVuz XR0+91pKE6JSE7YzTxBQixoKE8GkRYkrr+ekg= Received: by 10.42.133.9 with SMTP id f9mr5448678ict.137.1304388650077; Mon, 02 May 2011 19:10:50 -0700 (PDT) MIME-Version: 1.0 Received: by 10.42.165.70 with HTTP; Mon, 2 May 2011 19:10:10 -0700 (PDT) In-Reply-To: <379871.77718.qm@web161612.mail.bf1.yahoo.com> References: <379871.77718.qm@web161612.mail.bf1.yahoo.com> From: Pavel Stehule Date: Tue, 3 May 2011 04:10:10 +0200 Message-ID: Subject: Re: [SQL] PLpgSQL variables persistance between several functions calls To: "Charles N. Charotti" Cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201105/8 X-Sequence-Number: 25018 Hello no, it's not possible Regards Pavel Stehule 2011/5/2 Charles N. Charotti : > 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 > From willybas@gmail.com Tue May 3 10:20:59 2011 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 65AEF1337B49 for ; 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 ; 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: References: <379871.77718.qm@web161612.mail.bf1.yahoo.com> Date: Tue, 3 May 2011 12:20:47 +0200 Message-ID: Subject: Re: [SQL] PLpgSQL variables persistance between several functions calls From: Willy-Bas Loos To: "Charles N. Charotti" Cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org, Pavel Stehule 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 wrote: > Hello > > no, it's not possible > > Regards > > Pavel Stehule > > 2011/5/2 Charles N. Charotti : > > 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,

Maybe calling a function from within another function would be a so= lution to you.

Cheers,

WBL

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

Hello

no, it's not possible

Regards

Pavel Stehule

2011/5/2 Charles N. Charotti <cch= arotti@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-- From viktor.bojovic@gmail.com Tue May 3 11:14:32 2011 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A99561337BFB for ; Tue, 3 May 2011 08:14:32 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 27376-01-5; Tue, 3 May 2011 11:14:25 +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 B77DE1337C14; Tue, 3 May 2011 08:01:12 -0300 (ADT) Received: by vxi39 with SMTP id 39so4903465vxi.19 for ; Tue, 03 May 2011 04:01:12 -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=c3NcC/IuIfjrvZvX7PrsYzGJynWk9iEbx4BZTOGVelE=; b=L8D0LjI5qkxDgomvVRDmYJOel3VBIWVyzlUzDlk7iXbVMavHYL745snByD+7SvyaAF v/Q/A07YsUOKuJ898GFRLE2EAVQms8nbRuKi/L/HE217NZMWQgiAvYPCEK+BT3QT1zLA B6NUuAT4t9Vl7J4cVw7guf8o3oDIYvsigqrmQ= 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=gUbjUOT7YSRcqyseRMxCOjTKAiNl5WqvlSxPgbG/QBS2d5qrg8MjYmT2vZfrNF4bq+ U9oVs95JCv/S8sEWKnoPFPYY5mPiChtWbMTGxZLkLCZLor6JRnt09a2CxqlfP0MyQokH eRJyFLZwNRyWS+z8isWvfa+w0Ys8Wg9PPpa4k= MIME-Version: 1.0 Received: by 10.220.210.3 with SMTP id gi3mr2513774vcb.213.1304420472704; Tue, 03 May 2011 04:01:12 -0700 (PDT) Received: by 10.220.202.71 with HTTP; Tue, 3 May 2011 04:01:12 -0700 (PDT) In-Reply-To: <379871.77718.qm@web161612.mail.bf1.yahoo.com> References: <379871.77718.qm@web161612.mail.bf1.yahoo.com> Date: Tue, 3 May 2011 13:01:12 +0200 Message-ID: Subject: Re: [SQL] PLpgSQL variables persistance between several functions calls From: =?UTF-8?Q?Viktor_Bojovi=C4=87?= To: "Charles N. Charotti" Cc: pgsql-novice@postgresql.org, pgsql-sql@postgresql.org Content-Type: multipart/alternative; boundary=002354188914e9d1ad04a25d0e7e 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/14 X-Sequence-Number: 25024 --002354188914e9d1ad04a25d0e7e Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable the best way is to put all calls into one function and store values to variables.. if that is not suitable you can try the way (which im not sure if anyone uses) and it is to store values to sequences if value type is integer. for other formats you will have to do conversions. but im not sure if sequence values are stored in database or in memory. that way will make your results visible to all sessions. On Mon, May 2, 2011 at 11:43 PM, Charles N. Charotti w= rote: > 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 oth= er > methods). > > If it is really possible ? > > Thanks in advance, > > Chuck > --=20 --------------------------------------- Viktor Bojovi=C4=87 --------------------------------------- Wherever I go, Murphy goes with me --002354188914e9d1ad04a25d0e7e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable the best way is to put all calls into one function and store values to vari= ables..

if that is not suitable you can try the way (which im not su= re if anyone uses) and it is to store values to sequences if value type is = integer.
for other formats you will have to do conversions.
but im not sure if se= quence values are stored in database or in memory.
that way will make yo= ur results visible to all sessions.

On Mon, May 2, 2011 at 11:43 PM, Charles N. Charotti <= ccharotti@yahoo.com> w= rote:

Hello everybody !

I want to know if I could share PLpgSQL variables = between different functions and within different calls just using memory (n= ot tables or other methods).

If it is really possible ?

Thank= s in advance,

Chuck

--
-----= ----------------------------------
Viktor Bojovi=C4=87
--------------= -------------------------
Wherever I go, Murphy goes with me
--002354188914e9d1ad04a25d0e7e--