Thanks to both of you for responding. I should have included the code for my own attempt, at #1 which is just as you suggest: update item set itemname = 'fox'; I've tried single, and double quoting the table and field names; call caps to the UPDATE etc, exactly matching the capitalization of the table and field names (really Item and ItemName). I wonder if "Item" is a reserved word in pgsql? Shoaib Mir wrote: > > 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@xxxxxxxxx> 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 >> > > -- View this message in context: http://www.nabble.com/Simple-stored-procedure-examples--tf2572616.html#a7175841 Sent from the PostgreSQL - general mailing list archive at Nabble.com.
