From 11f7b29054fd24c7e6dd1d2a8734cbebf3585b25 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 5 Nov 2000 00:15:54 +0000 Subject: 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. --- src/backend/utils/adt/ruleutils.c | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'src/backend/utils/adt/ruleutils.c') 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); } } -- cgit v1.2.3