On Thu, Jan 27, 2011 at 11:45:30PM -0800, Jeff Davis wrote: > Updated patch. > > Changes: > > * Documentation for operators/functions > * a comprehensive set of operators and functions > * BTree opclass
Yay! > * Hash opclass > * built-in range types: > - PERIOD (timestamp) > - PERIODTZ (timestamptz) For consistency, and in order not to continue our atrocious naming tradition, I'd like to propose that the above be named timestamprange (tsrange for short) and timestamptzrange (tstzrange for short). > - DATERANGE (date) Yay! > - INTRANGE (int4) int4range/intrange and the missing bigintrange/int8range > - NUMRANGE (numeric) numericrange/numrange. Should there also be a timerange and a timetzrange? > * added subtype float function to the API, which will be useful for > GiST w00t! > * created canonical functions for intrange and daterange, so that: > '[1,5]'::intrange = '[1,6)'::intrange Excellent! > * added length() function, written in SQL as: > select upper($1) - lower($1) > which uses polymorphic "-" operator to avoid the need to > give the subtype subtract function and return type to the generic > API > > Open items: > > * More documentation work > * Settle any representation/alignment concerns > * Should the new length() function be marked as immutable, stable, > or volatile? It uses the polymorphic "-" operator, and I suppose > someone could define a non-immutable version of that before calling > length(). Then again, it is likely to be inlined anyway, right? > * GiST > - docs > - catalog work > - implementation > * typmod support (optional) > > This is nearing completion. GiST is by far the most amount of effort > remaining that I'm aware of. Comments about the API, naming, > representation, interface, funcationality, grammar, etc. are welcome. > > Regards, > Jeff Davis I'd offer to help, but personal matters press this weekend :) Cheers, David. -- David Fetter <da...@fetter.org> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
