Roy> The 'constraint' (interval type descriptor or whatever it's
Roy> really called) is mandatory in standard SQL, I think, so
Roy> there's no ambiguity anyway, unless anyone is using this
Roy> undocumented syntax at the moment...
Incidentally, this was the ratinale behind my earlier suggestion, that:
* if the interval type descriptor is absent, parse the interval as a
traditional postgres interval
* if the interval type descriptor is present, parse the interval according
to the standard syntax
I have no objection to allowing things like
'1 hour 10 minutes' DAY TO SECOND
but I'm just wondering whether the hybrid syntax is an unnecessary
complication.
-roy
