> Bruce Momjian writes: > > > > Break the SQL code that has been implemented for prior versions?? > > > Bummer ;((. > > > > Yes, but we don't follow the MySQL behavior, which we copied when we > > added LIMIT. Seems we should agree with their implementation. > > Isn't it much worse to not follow PostgreSQL behavior than to not follow > MySQL behavior?
Another idea: because our historical Limit #,# differs from MySQL, one idea is to disable LIMIT #,# completely and instead print an error stating they have to use LIMIT # OFFSET #. Although that would break both MySQl and old PostgreSQL queries, it would not generate incorrect results. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
