Re: plpgsql function
On Tue, Nov 07, 2000 at 10:24:19AM -0300, Lamas Osvaldo wrote:
> Hello!!
>
> I'm an Argentine programmer,so please ,excuse me if my english is very poor.
>
> I have a lot of questions.I was working whith "Store Procedures",more
> exactly with plpgsql language.
> I need to know if it is posible,where can I found a complete reference of
> this language.
apt-get install postgresql-doc
> One of my problems is :
>
> I have an update statement and I need to know how many rows it's command
> updates..how it is posible??..
> Thanks for your help...
The regular UPDATE statement returns this number. So, depending on how
your procedures are constructed, you may be able to get this as a return
value. Or, if you're working in a looping construct, count the number
of records you change.
--
#! /bin/sh
# ppp-address: What's my Internet Address for ppp0 ?
/sbin/ifconfig ppp0 2> /dev/null | grep 'inet addr:' | sed \
's=.*inet addr\:\([0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\.[0-9]\{1,3\}\).*=\1='
Reply to: