[SQL] Variables in PSQL

2002-07-09 Thread 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

[SQL] signed/unsigned integers

2002-08-28 Thread 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

2002-08-29 Thread 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 messag