Re: Porting Code to Postgresql

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Porting Code to Postgresql
Date: 2003-10-15 15:43:07
Message-ID: 3F8D6B0B.9010900@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>$count = pg_numrows( $result);
>for( $i = 0; $i < $count; $i++){
> $row = pg_fetch_object( $result, $row);
> ...
>}
>
>if you want it to work.
>
>
>
in case of no rows, maybe do:

$count = pg_numrows( $result);
while ( 0 < $result ){
$result--;
$row = pg_fetch_object( $result, $row);
...
}

or

$count = pg_numrows( $result);
$offset = $count;
while ( 0 < $offset ){
$offset--;
$row = pg_fetch_object( $result-$offset, $row);
...
}

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-10-15 15:53:59 Re: Cygwin? or paid version from SRA?
Previous Message Stephen 2003-10-15 15:37:35 VACUUM degrades performance significantly. Database becomes unusable!