Re: Simple stored procedure examples?

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

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