[SQL] Variables in PSQL

[Roger Mathis]

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





---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] signed/unsigned integers

[Roger Mathis]

Hi

Is it true, that I can't define unsigned integers in a table definition?

CU Roger



---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] signed/unsigned integers

[Roger Mathis]

Hi

Is it true, that I can't define unsigned integers in a table definition?

CU Roger




---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly