This has to be absolutely the funniest replies ever. I am sure Gilles meant to ask something else altogether, but we will never know until Gilles asks that. In the meantime, ;-)
On 7/29/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > Gilles Ganault <gilles.ganault-jG/[EMAIL PROTECTED]> > wrote: > > Is there a way to know which rows will be changed by a query like > > this? > > > > UPDATE suppliers SET name = 'HP' WHERE name = 'IBM'; > > Sure: > > select rowid from suppliers where name='IBM'; > > Igor Tandetnik > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ S&T Policy Fellow, National Academy of Sciences http://www.nas.edu/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------