Re: Distinct types

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Distinct types
Дата
Msg-id 493021FF.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Distinct types  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Distinct types  ("Greg Stark" <stark@enterprisedb.com>)
Список pgsql-hackers
>>> Tom Lane <tgl@sss.pgh.pa.us> wrote: 
> 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.
This by itself doesn't justify the effort, but I've worked with
databases which would refuse to allow comparison (including within
JOIN conditions) of values if they were in different domains, and I
miss that.  It would occasionally keep people from making dumb
mistakes that wasted time.  It would also be nice to be able to
prevent inappropriate use of data, as previously mentioned.  I'm
afraid I don't have any interest less mundane than that, and ease of
use would need to be there in order for it to be useful.
I would actually like to see comparisons to literals or expressions of
the base type work, although that doesn't seem to be in line with the
SQL spec, and I suspect it might not play nice with the implicit
casting.
-Kevin


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: HEAD build failure on win32 mingw
Следующее
От: "Greg Stark"
Дата:
Сообщение: Re: Distinct types