Re: Boolean partitions syntax - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Boolean partitions syntax
Date
Msg-id 11929.1517608824@sss.pgh.pa.us
Whole thread Raw
In response to Re: Boolean partitions syntax  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Boolean partitions syntax
List pgsql-hackers
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> There might be other options, but one way to solve this would be to
> treat partition bounds as a general expression in the grammar and then
> check in post-parse analysis that it's a constant.

That's pretty much what I said upthread.  What I basically don't like
about the current setup is that it's assuming that the bound item is
a bare literal.  Even disregarding future-extension issues, that's bad
because it can't result in an error message smarter than "syntax error"
when someone tries the rather natural thing of writing a more complicated
expression.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Parallel tuplesort (for parallel B-Tree index creation)
Next
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] proposal: schema variables