>
> 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
