diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-10-26 21:38:24 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-10-26 21:38:24 +0000 |
| commit | 2f35b4efdbec6c161ca9bd491d6345134910c425 (patch) | |
| tree | 2424351bcc12a8ddf2b716b28f53d2c37c79e507 /src/backend/rewrite/rewriteDefine.c | |
| parent | c9476bafdb1b97d0d21d92788f93298962145479 (diff) | |
| download | postgresql-2f35b4efdbec6c161ca9bd491d6345134910c425.tar.gz postgresql-2f35b4efdbec6c161ca9bd491d6345134910c425.zip | |
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.
Diffstat (limited to 'src/backend/rewrite/rewriteDefine.c')
| -rw-r--r-- | src/backend/rewrite/rewriteDefine.c | 8 |
1 files changed, 1 insertions, 7 deletions
diff --git a/src/backend/rewrite/rewriteDefine.c b/src/backend/rewrite/rewriteDefine.c index c08ddbc6782..a83e0202335 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 $ * *------------------------------------------------------------------------- */ @@ -305,12 +305,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. */ expected_name = MakeRetrieveViewRuleName(event_obj->relname); |