On Sep21, 2011, at 19:00 , Jeff Davis wrote: > While we're at it, any suggestions on the text representation of an > empty range?
My personal favourite would be '0', since it resembles the symbol used for empty sets in mathematics, and we already decided to use mathematical notation for ranges. If we're concerned that most of our users won't get that, then 'empty' would be a viable alternative I think. From a consistency POV it'd make sense to use a bracket-based syntax also for empty ranges. But the only available options would be '()' and '', which are too easily confused with '(,)' and '[,]' (which we already decided should represent the full range). best regards, Florian Pflug -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers