Thanks for all answers!
Unfortunatly, faking them with some C functions would be very complex because in this application's case most of this variables are record types and some are arrays (pl/tables)... :-(
It seems that creating temp tables (and some api functions) would be a little bit easier to implement. One concern would be about preformance: I guess that temp tables are written to disk and fetched as any other table but discarded in the end of the session.
Any suggestion or comments?
Thanks again, Ronnie
Joe Conway escreveu em 6/1/2005 21:57:
Ronnie Meier Ramos wrote:
AFAIK PG doesn't have packages - this is not a problem since I can handle it with different schemas or some naming convention, but is there a way to declare persistent variables (that would be "visible" to any function up to the end of the session) ?
You might be able to fake it with some C functions. See:
http://www.joeconway.com/myfunc.tgz
Look at myfunc_setvar(), myfunc_getvar(), and myfunc_rmvar().
HTH,
Joe
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
begin:vcard fn:Ronnie Meier Ramos n:Ramos;Ronnie org;quoted-printable:Viler Cal=C3=A7ados Ltda. adr;quoted-printable:;;RS 239, n=C2=BA500;Novo Hamburgo;RS;93352-000;Brasil email;internet:[EMAIL PROTECTED] title;quoted-printable:Gerente de Inform=C3=A1tica tel;work:+55 (51) 2129-3800 tel;fax:+55 (51) 2129-3801 x-mozilla-html:TRUE version:2.1 end:vcard
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
