Thread: Variables in PSQL

Variables in PSQL

From
"Roger Mathis"
Date:
Hi

I'm trying to declare a variable in PostgreSQL, so I can save some values in
it. After, I want to calculate with this variable.
For example:

declare vp integer;
select price into :vp from article where anr = 1;
vp := vp + 1;
update article set price = :vp where anr = 1;

Is there a posibility to do that without creating a funktion?
Thanks for your answers.

CU Roger






Re: Variables in PSQL

From
Christoph Haller
Date:
> 
> I'm trying to declare a variable in PostgreSQL, so I can save some values in
> it. After, I want to calculate with this variable.
> For example:
> 
> declare vp integer;
> select price into :vp from article where anr = 1;
> vp := vp + 1;
> update article set price = :vp where anr = 1;

AFAIK, you can do stuff like this only within a function. 
> 
> Is there a posibility to do that without creating a funktion?

What about 
update article set price =(select price + 1 from article where anr = 1)
where anr = 1; 

Regards, Christoph