Re: PHP & PostgreSQL

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 */