On Jun29, 2011, at 19:05 , David E. Wheeler wrote: > I'm still not clear, though, on why the return type of range() > should not be related to the types of its arguments. So > > range(1, 5) > > Should return intrange, and > > range(1::int8, 5::int8) > > Should return int8range, and > > range('foo', 'foooo') > > Should return textrange.
Because there might be more than one range type for a base type. Say there are two range types over text, one with collation 'de_DE' and one with collation 'en_US'. What would the type of range('foo', 'foooo') be? best regards, Florian Pflug -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers