A new currency type would be nice, and if kept small in scope, might be manageable. Bringing Christoph Berg's PostgreSQL-units into core and extending it could be interesting. Peter E's URL and email types might be good candidates. What else? Informix Datablades had a media type way back in the day... That's still a gap in community Postgres.
On Mon, Jan 16, 2017 at 6:43 PM, Jim Nasby <jim.na...@bluetreble.com> wrote: > On 1/13/17 3:09 PM, Peter van Hardenberg wrote: > >> A new data type, and/or a new index type could both be nicely scoped >> bits of work. >> > > Did you have any particular data/index types in mind? > > Personally I'd love something that worked like a python dictionary, but > I'm not sure how that'd work without essentially supporting a variant data > type. I've got code for a variant type[1], and I don't think there's any > holes in it, but the casting semantics are rather ugly. IIRC that problem > appeared to be solvable if there was a hook in the current casting code > right before Postgres threw in the towel and said a cast was impossible. > > 1: https://github.com/BlueTreble/variant/ > > -- > Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX > Experts in Analytics, Data Architecture and PostgreSQL > Data in Trouble? Get it in Treble! http://BlueTreble.com > 855-TREBLE2 (855-873-2532) > -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt."—Kurt Vonnegut