Skip site navigation (1) Skip section navigation (2)

Re: Distinct types

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Distinct types
Date: 2008-11-28 16:38:45
Message-ID: 1227890325.20796.204.camel@hp_dx2400_1 (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
On Fri, 2008-11-28 at 11:20 -0500, Tom Lane wrote:
> Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > Simon Riggs wrote:
> >> Shame, this was sorely needed.
> > I understand, but the work required to make it work properly is too much 
> > under the commit fest spirit right now.
> Personally I was wondering exactly why it's "sorely needed".  There has
> been not one field request for this functionality; in fact I'd never
> heard of the feature until Peter popped up with his patch.  I assumed he
> was simply trying to see if we could tick off another SQL feature
> checkbox with a small number of lines of code.
> If it's going to take a significant amount of work then I think someone
> ought to provide an actual justification why it's worth the work.

Few thoughts: 

* Domains don't work very well in conjunction with arrays. 

* Strong typing is preferable in complex applications to avoid errors
like sum(ordinal_column). Most developers use this all the time in their
3GL code but cannot use it in SQL.

* Allows migration of code easier from places that use strange sounding
datatypes that can be mapped easily to existing datatypes.

 Simon Riggs 
 PostgreSQL Training, Services and Support

In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2008-11-28 16:44:36
Subject: Re: Review: Hot standby
Previous:From: Simon RiggsDate: 2008-11-28 16:31:45
Subject: Re: Review: Hot standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group