Unix Technical Forum

Re: Static Variables in PL/PGSQL

This is a discussion on Re: Static Variables in PL/PGSQL within the pgsql Novice forums, part of the PostgreSQL category; --> am 14.12.2005, um 16:30:34 -0500 mailte Michael Dengler folgendes: > Hi, > > Is here a way to use ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Novice

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 10:24 PM
A. Kretschmer
 
Posts: n/a
Default Re: Static Variables in PL/PGSQL

am 14.12.2005, um 16:30:34 -0500 mailte Michael Dengler folgendes:
> 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?


A table?


HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 04:01 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com