Tom Lane dijo:
> Yury Bokhoncovich <byg(at)center-f1(dot)ru> writes:
> > Imagine typical usage of LIMIT/OFFSET: pagination of a web-output.
> > Say, the output is fetched thru "select id,body from articles limit 10
> > offset 20".
> > Now, content-admin, surfing the content and looking to the page say 2,
> > wanna drop all info on THAT page 2.
> > Guess how it could ease the life for programmer?8)
I don't understand. It's somewhat more difficult to grab all the
primary keys of the currently-selected items (and you can put a
how is it better to be unsure if you are really deleting what you want
to delete? Suppose another admin is also deleting and the LIMIT/OFFSET
shifts between the time the page is presented and the button "delete
these" is pressed...
"Hey, PostgreSQL is stupid," they'll say. "How can they offer such an
Alvaro Herrera (<alvherre[a]atentus.com>)
"God is real, unless declared as int"
In response to
pgsql-patches by date
|Next:||From: Joe Conway||Date: 2002-09-23 17:42:58|
|Subject: Re: contrib/dblink regression test failure fix|
|Previous:||From: Tom Lane||Date: 2002-09-23 17:02:38|
|Subject: Re: contrib/dblink regression test failure fix |