Re: Declarative partitioning - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Declarative partitioning
Date
Msg-id CADkLM=e93X+iZw+YX2M4wjOOtSu1PN-Xre=hkK=s3WLFtFpJBQ@mail.gmail.com
Whole thread Raw
In response to Re: Declarative partitioning  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers

I think we're converging on a good syntax, but I don't think the
choice of nothingness to represent an open range is a good idea, both
because it will probably create grammar conflicts now or later and
also because it actually is sort of confusing and unintuitive to read
given the rest of our syntax.  I suggest using UNBOUNDED instead.


As much as it reminds me of the window syntax I loathe (ROWS BETWEEN UNBOUNDED ....gah), I'm inclined to agree with Robert here. 

It also probably helps for code forensics in the sense that it's easier to text search for a something than a nothing.
 

pgsql-hackers by date:

Previous
From: Corey Huinker
Date:
Subject: Re: raw output from copy
Next
From: Andrew Dunstan
Date:
Subject: enums and indexing