On Monday 30 December 2002 18:13, Boget, Chris wrote:
> I'm switching from a MySQL environment to PGSQL and I'm
> going through and trying to learn the differences between the
> two. I've come across some issues that I can't seem to find the
> answers to in the docs or on the web. I'm hoping someone can
> help me out.
>
> * MySQL has a function to reset the result set so that it can be
> iterated through again - mysql_data_seek(). I don't see that there
> is a similar function for PGSQL. Is that true? If so, in order to
> reset the result set you have to perform the query again? Isn't
> that a waste of resources?
pg_result_seek() should perform a similar function. In most cases you wouldn't
need to use that because if you're going to be using the results more than
once you could store them in an array.
> * For PGSQL, you can get the database name, the field name
> even the *host name* but you can't get the table name from a
> particular query?
Not sure what you're getting at here. Surely for any particular query, _you_
would know what table(s) is/are being used?
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
In Hollywood, all marriages are happy. It's trying to live together
afterwards that causes the problems.
-- Shelley Winters
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
