On 01/09/2018 10:59 PM, Tom Lane wrote: > Generally speaking, Postgres tries hard to be an extensible-datatype > system, going beyond the SQL standard's minimum requirements when > necessary to make it so. The reason that we don't already have RANGE > PRECEDING/FOLLOWING support is that nobody was satisfied with only > making it work for integers and datetimes. There was, as I recall, code > implementing more or less what you've got here in the original window > function submission, and we pulled it out before committing because of > that inadequacy. I don't think the fact that some years have gone by > means that we should forget about keeping the feature extensible.
I'm glad I read the thread before I replied. My biggest complaint I had in my head when reading the initial post was that clamping down on specific datatypes was distinctly non-PostgreSQL-esque. I'm -1 on such a patch, even though I would really like this feature. -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
