Re: deleting an identical record
От | Oliver Elphick |
---|---|
Тема | Re: deleting an identical record |
Дата | |
Msg-id | 1014287488.13241.237.camel@linda обсуждение исходный текст |
Ответ на | Re: deleting an identical record (Jean-Luc Lachance <jllachan@nsd.ca>) |
Список | pgsql-general |
On Thu, 2002-02-21 at 09:25, Jean-Luc Lachance wrote: > Oliver Elphick wrote: > > > create table t (a int, b text); > > > > > > insert into t values (1, 'a'); > > > insert into t values (1, 'a'); > > > insert into t values (1, 'a'); > > > insert into t values (1, 'a'); > > > > > > select oid, * from t; > > > > Aren't the oids different? > > > > DELETE FROM t WHERE oid <> xxx > > > OUCH !!! There will be only one row left in the table. Be carefull. True. But in my defence, that is valid in the context of this particular example. (Nevertheless, I was right only by accident and your warning is very necessary.) -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "My sheep hear my voice, and I know them, and they follow me; And I give unto them eternal life; and they shall never perish, neither shall any man pluck them out of my hand." John 10:27,28
В списке pgsql-general по дате отправления: