I need to be able to read/identify a specific record from both MySQL and PostgreSQL dbs using php(4).
I have done this in the past when using Progress (RDBMS/4GL) by using the ROWID(tablename) function in the where clause eg '... where rowid(customer) = &custRowid ...'. These functions make Progress bypasses the indexes an go directly to the specified record. Progress maintains the rowid of all records (ie they are read only). The rowid is actually what the index references to locate records.
Does anyone know if php, mysql & postgresql support anything like the progress's rowid - if not is there a more efficient way of doing this other than creating an id field for each table and generating an index (on each table) using just this field?
Thanks in advance
Tim Huffam
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
I have done this in the past when using Progress (RDBMS/4GL) by using the ROWID(tablename) function in the where clause eg '... where rowid(customer) = &custRowid ...'. These functions make Progress bypasses the indexes an go directly to the specified record. Progress maintains the rowid of all records (ie they are read only). The rowid is actually what the index references to locate records.
Does anyone know if php, mysql & postgresql support anything like the progress's rowid - if not is there a more efficient way of doing this other than creating an id field for each table and generating an index (on each table) using just this field?
Thanks in advance
Tim Huffam
<!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->