Commite1ce520

committed

Back out LIMIT #,# removal and mark it as to-be-removed in 7.3.

1 parent087771a commite1ce520Copy full SHA for e1ce520

File tree

-4

lines changed

-4

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -37,9 +37,9 @@ several languages.`
`37`	`37`	`Migration to 7.2`
`38`	`38`
`39`	`39`	`A dump/restore using pg_dump is required for those wishing to migrate`
`40`		`- data from any previous release.One significant change is that`
`41`		`-the SELECT ... LIMIT 10,20 syntax is no longer supported. You must`
`42`		`-now use LIMIT 10OFFSET 20 to accomplish the same thing.`
	`40`	`+ data from any previous release.The SELECT ... LIMIT 10,20 syntax will`
	`41`	`+be removed in 7.3. You should change your queries to use LIMIT 10`
	`42`	`+ OFFSET 20.`
`43`	`43`
`44`	`44`
`45`	`45`

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@`
`11`	`11`	`*`
`12`	`12`	`*`
`13`	`13`	`* IDENTIFICATION`
`14`		`- * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.267 2001/10/20 16:51:02 momjian Exp $`
	`14`	`+ * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.268 2001/10/23 02:45:37 momjian Exp $`
`15`	`15`	`*`
`16`	`16`	`* HISTORY`
`17`	`17`	`* AUTHORDATEMAJOR EVENT`
`@@ -3656,7 +3656,11 @@ select_limit:LIMIT select_limit_value OFFSET select_offset_value`
`3656`	`3656`	`\|OFFSETselect_offset_value`
`3657`	`3657`	`{$$ = makeList2($2,NULL); }`
`3658`	`3658`	`\|LIMITselect_offset_value','select_limit_value`
	`3659`	`+{$$ = makeList2($4,$2); }`
	`3660`	`+#ifdefNOT_USED`
	`3661`	`+/* enable this in 7.3, bjm 2001-10-22*/`
`3659`	`3662`	`{ elog(ERROR,"LIMIT #,# syntax no longer supported.\n\tUse separate LIMIT and OFFSET clauses."); }`
	`3663`	`+#endif`
`3660`	`3664`	`;`
`3661`	`3665`
`3662`	`3666`

Comments

(0)