You can use the following:
>>#1 updating ItemName for all rows to 'fox'
update tablename set itemname = 'fox';
>>#2 updating ItemName for row where ItemID = 2 to 'fox'
update tablename set itemname = 'fox' where itemid = 2;
>>#3 updating ItemName for row where ItemID = 3 to a param value passed in
\set var1 3;
update tablename set itemname = 'testing' where itemid = :var1;
Hope this helps...
Thanks,
-------
Shoaib Mir
EnterpriseDB (
www.enterprisedb.com)
On 11/4/06, novnov < novnovice@gmail.com> wrote:
I'm completely new to pgsql, using 8.1 and pgAdmin III. I'm not finding a lot
of bare bones simple example stored procs that I can learn from. It would be
very helpful if someone could show me some simple code.
In the pgAdmin interface I've been picking SQL as the language, that's the
default it offers.
Say I have a table Item, and fields ItemID (int4) and ItemName (varchar).
What would be the code for
#1 updating ItemName for all rows to 'fox'
#2 updating ItemName for row where ItemID = 2 to 'fox'
#3 updating ItemName for row where ItemID = 3 to a param value passed in
That would be so helpful...I've tried and get errors like "ERROR relation
"item" does not exist", and of course the table Item and the column ItemName
do exist, haven't been able to figure out what the error means.
--
View this message in context: http://www.nabble.com/Simple-stored-procedure-examples--tf2572616.html#a7171726
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings