Re: variables outside of functions - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: variables outside of functions
Date
Msg-id 20060204210957.GA23797@KanotixBox
Whole thread Raw
In response to variables outside of functions  ("Ketema J. Harris" <ketema@ketema.net>)
List pgsql-novice
Ketema J. Harris <ketema@ketema.net> schrieb:

> Is it possible to write a block of sql statements that utilize  variables?
> I can use variables easy enough inside of a function, but  I was attempting

You can use languages like plperl to use variables within one session.
(persistent variables, a little example with german comments are here:
http://a-kretschmer.de/pgsql/pgsql-4.php, function prev_saldo)


HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-novice by date:

Previous
From: Jan Danielsson
Date:
Subject: Select date & time
Next
From: Andreas Kretschmer
Date:
Subject: Re: Select date & time