Re: Delete/update with limit

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Marco Colombo <pgsql(at)esiway(dot)net>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete/update with limit
Date: 2007-07-24 15:32:43
Message-ID: 1185291163.8615.27.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Unfortunately the stuff that makes a ctid=<value> nice doesn't seem to be
> used when you're doing an in. It's possible that a function that does
> something like
> for rec in select ctid from my_table limit 10 loop
> delete from my_table where ctid=rec.ctid;
> end loop
> might do okay, but I haven't tried it.

OK, I think this will work. It would be nice though to have the 'ctid
in' trick work just as well as 'ctid = ' ...

Thanks,
Csaba.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Wampler 2007-07-24 15:45:57 Re: CentOS 4 RPMs for 8.2.4?
Previous Message Gregory Stark 2007-07-24 15:30:24 Re: varchar does not work too well with IS NOT NULL partial indexes.