Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Дата
Msg-id 11687.1251295661@sss.pgh.pa.us
обсуждение исходный текст
Ответ на PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query  (Jean-Michel Pouré <jm@poure.com>)
Список pgsql-hackers
Jean-Michel Pouré <jm@poure.com> writes:
> Analysing slow queries, I noticed that PostgreSQL 8.4 would cast data
> from int4 to int_unsigned.

> Details and query plan: http://drupal.org/node/559986
> Some queries range between 400ms and 700ms.

I see no reason whatever to think that that domain has anything to do
with the choice of query plan.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: PostgreSQL does CAST implicitely between int and a domain derive from int during SELECT query