Re: Distinct types
От | Simon Riggs |
---|---|
Тема | Re: Distinct types |
Дата | |
Msg-id | 1227890325.20796.204.camel@hp_dx2400_1 обсуждение исходный текст |
Ответ на | Re: Distinct types (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Distinct types
|
Список | pgsql-hackers |
On Fri, 2008-11-28 at 11:20 -0500, Tom Lane wrote: > Peter Eisentraut <peter_e@gmx.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.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: