Re: NAB : insert into select distinct => when used on null, distinct causes loss of type knowledge
Поиск
Список
Период
Сортировка
От Frank van Vugt
Тема Re: NAB : insert into select distinct => when used on null, distinct causes loss of type knowledge
Дата
Msg-id 200408242337.02757.ftm.van.vugt@foxi.nl
обсуждение исходный текст
Ответ на Re: NAB : insert into select distinct => when used on null, distinct causes loss of type knowledge  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi Tom,

> No, because it never had any: NULL is typeless (type UNKNOWN, to the
> parser). But to do a DISTINCT, the parser has to assign datatypes to all the
> columns (to determine the comparison rules).  The default assumption for an
> UNKNOWN constant is type TEXT.

I grok, thanks for the quick reply.



--
Best,




Frank.


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

Предыдущее
От: "Christine Desmuke"
Дата:
Сообщение: Gentoo for production DB server?
Следующее
От: Greg Donald
Дата:
Сообщение: Re: Gentoo for production DB server?