Re: Variables in PSQL

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