|
From: Colin B. <col...@te...> - 2002-10-10 01:05:08
|
> I'm curious. If the DB contains two rows that differ only in a > BLOB > field, how would a user use standard SQL to change only one row? > I'm > assuming that the DB does not use unique row identifiers (Oracle's > rowID > or Postgres' OID), because that would prevent this from happening > (remember that I'm proposing to use any such unique pseudo field > as part > of the query/update statement). AFAIK they couldn't. Another reason to have a primary key defined for every table. -- Colin Bell http://squirrel-sql.sf.net |
