Re: To Postgres Devs : Wouldn't changing the select limit
От | Mitch Vincent |
---|---|
Тема | Re: To Postgres Devs : Wouldn't changing the select limit |
Дата | |
Msg-id | 01a401c1582d$b3267860$e05c5dd8@mitch обсуждение исходный текст |
Ответ на | Re: To Postgres Devs : Wouldn't changing the select limit (Philip Hallstrom <philip@adhesivemedia.com>) |
Список | pgsql-general |
LIMIT m OFFSET m *is* there now.. There is a LIMIT m,n syntax too I guess, though it appears that it's backwards from MySQL.. I don't see much point in having two different ways of doing the same thing unless you wanted to maintain compatibility with another RDBMS - but that doesn't appear to be the case here (isn't that reversed from the MySQL implementation?).. However, removing it now is going to break people's SQL.. I didn't know you could LIMIT m,n until today so I wouldn't have a clue as to how many people actually use that syntax. Perhaps the idea of tossing a notice up that that syntax is going away in the next release would be a better idea than just yanking it out right away - then we can see how many people complain :-) -Mitch > As a user of both MySQL and PostgreSQL I can say that I would *love* it if > you went with "LIMIT n OFFSET m" instead of "LIMIT m,n". *every* time I > use the offset feature I have to look it up in the manual or some other > code snippet that has it (and where it's clear). > > Even it broke some script I'd written it's pretty easy to find and fix > it...
В списке pgsql-general по дате отправления: