Static Variables in PL/PGSQL

From: "Michael Dengler" <xchargerx(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Static Variables in PL/PGSQL
Date: 2005-12-14 21:30:34
Message-ID: BAY104-F7173A3733DA3AD735D823A7380@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

Is here a way to use static variables in PL/PGSQL?

I have a recursive PL/PGSQL function and need to execute a code only on the
first iteration of the function (I need to be able to count the function
iterations).

Any help?

Mike

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-12-14 22:22:54 Re: Sequence on a char(6) column
Previous Message Brad Nicholson 2005-12-14 20:28:08 Re: Repercussions of killing a vacuum