Paul Harris <[EMAIL PROTECTED]> wrote:
On 03/08/07, Nikola Miljkovic
<[EMAIL PROTECTED]> wrote:
This is certainly true, but there might be cases where one wants
to keep certain results between sql statements and reuse them.
While this conceptual solution is certainly not the Variable
it sort of gets the job done.
create temporary table vars (name text, value something);
--
insert into vars set name="x", value=0;
--
... where something = (select value from vars where name="x")...
I tried doing this, but there doesn't seem to be a way to do the same
thing with an UPDATE command ?
No way to do what with UPDATE command? What exactly are you trying to
do, and failing?
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
