Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] To Postgres Devs : Wouldn't changing the selectlimit

From: David Ford <david(at)blue-labs(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] To Postgres Devs : Wouldn't changing the selectlimit
Date: 2001-10-23 05:07:23
Message-ID: 3BD4FB0B.6010205@blue-labs.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Not possible to accept both forms at present and issue a notice that 
LIMIT m,n is deprecated?

If LIMIT m,n is found, internally re-write it to LIMIT m OFFSET n and 
press on.

This should appease everyone and still allow the 'proper' form to be 
implemented right now.  There isn't just the question of when it appears 
in pgsql, but when it appears in everyone else's code that depends on 
postgres.  If you delay LIMIT..OFFSET, then I too am affected in my 
code.  If I use it today and my code is in beta (which it is), then when 
it goes release, I'll have to issue a change in the future for that. 
 Granted it's not a big thing for me, but if I have 200,000 
installations, that means eventually there will have to be 200,000 
upgrades when they upgrade postgres.

We all know that everyone updates their software frequently and in a 
timely manner to keep things running smoothly, right?  *cough*

David

Tom Lane wrote:

>Given the amount of noise being raised on the issue now, I think the
>better part of valor is to revert to the 7.1 behavior and plan to
>discuss it again for 7.3.  But it's not like Bruce did this with no
>warning or discussion.
>



In response to

Responses

pgsql-hackers by date

Next:From: Reiner DassingDate: 2001-10-23 07:01:04
Subject: Re: Index of a table is not used (in any case)
Previous:From: Josh BerkusDate: 2001-10-23 04:50:57
Subject: Re: Index of a table is not used (in any case)

pgsql-general by date

Next:From: Hiroshi InoueDate: 2001-10-23 05:19:50
Subject: Re: [ODBC] Writing BLOBS to pgsql via ODBC using VB
Previous:From: Keary SuskaDate: 2001-10-23 04:35:14
Subject: UNION bug in 7.1.3?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group