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 or flat)
Thread:
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           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

Responses

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-2014 The PostgreSQL Global Development Group