diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-11-05 00:15:54 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-11-05 00:15:54 +0000 |
| commit | 11f7b29054fd24c7e6dd1d2a8734cbebf3585b25 (patch) | |
| tree | 917e7ebbac724a341962e09cb9c775eaf2d1bab4 /src/backend/utils | |
| parent | 66436e66e1bfffb6ba3f11114c5b825e56437e7d (diff) | |
| download | postgresql-11f7b29054fd24c7e6dd1d2a8734cbebf3585b25.tar.gz postgresql-11f7b29054fd24c7e6dd1d2a8734cbebf3585b25.zip | |
Allow ORDER BY, LIMIT in sub-selects. Fix most (not all) cases where
the grammar did not allow redundant parentheses around sub-selects.
Distinguish LIMIT ALL from LIMIT 0; make the latter behave as one would
expect.
Diffstat (limited to 'src/backend/utils')
| -rw-r--r-- | src/backend/utils/adt/ruleutils.c | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/src/backend/utils/adt/ruleutils.c b/src/backend/utils/adt/ruleutils.c index 70dfe9706bc..cc25a5a026a 100644 --- a/src/backend/utils/adt/ruleutils.c +++ b/src/backend/utils/adt/ruleutils.c @@ -3,7 +3,7 @@ * back to source text * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.67 2000/10/26 21:37:45 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/utils/adt/ruleutils.c,v 1.68 2000/11/05 00:15:53 tgl Exp $ * * This software is copyrighted by Jan Wieck - Hamburg. * @@ -941,7 +941,11 @@ get_select_query_def(Query *query, deparse_context *context) if (query->limitCount != NULL) { appendStringInfo(buf, " LIMIT "); - get_rule_expr(query->limitCount, context); + if (IsA(query->limitCount, Const) && + ((Const *) query->limitCount)->constisnull) + appendStringInfo(buf, "ALL"); + else + get_rule_expr(query->limitCount, context); } } |