From 2f35b4efdbec6c161ca9bd491d6345134910c425 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 26 Oct 2000 21:38:24 +0000 Subject: Re-implement LIMIT/OFFSET as a plan node type, instead of a hack in ExecutorRun. This allows LIMIT to work in a view. Also, LIMIT in a cursor declaration will behave in a reasonable fashion, whereas before it was overridden by the FETCH count. --- src/backend/rewrite/rewriteDefine.c | 8 +------- 1 file changed, 1 insertion(+), 7 deletions(-) (limited to 'src/backend/rewrite/rewriteDefine.c') diff --git a/src/backend/rewrite/rewriteDefine.c b/src/backend/rewrite/rewriteDefine.c index c08ddbc678..a83e020233 100644 --- a/src/backend/rewrite/rewriteDefine.c +++ b/src/backend/rewrite/rewriteDefine.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteDefine.c,v 1.54 2000/10/05 19:11:34 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/rewrite/rewriteDefine.c,v 1.55 2000/10/26 21:36:50 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -304,12 +304,6 @@ DefineQueryRewrite(RuleStmt *stmt) } } - /* - * LIMIT in view is not supported - */ - if (query->limitOffset != NULL || query->limitCount != NULL) - elog(ERROR, "LIMIT clause not supported in views"); - /* * ... and finally the rule must be named _RETviewname. */ -- cgit v1.2.1