Re: [GENERAL] Numeric type in PL/pgSQL trigger: overflow problem - Mailing list pgsql-general

Hi all,

I'm trying to do the equivalent of the following command of
mysql (inside PHP3 code) in postgreSQL.

while (($row = mysql_fetch_object($result))) .....

I know there is the pg_fetch_object($result, ?) but I don't
know what to use for ?. I tried 0 and it does an exhaustive
search. I tried using something like $num

$num=0
while (($row = mysql_fetch_object($result,$num))) ...

$num++;

this is the error message I get :

Warning: Unable to jump to row 1 on PostgresSQL result index 2

Any ideas ?

thanks,
-Sheila
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com