Re: OUTER JOIN performance regression remains in 8.3beta4

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: OUTER JOIN performance regression remains in 8.3beta4
Дата
Msg-id 477E70B1.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: OUTER JOIN performance regression remains in 8.3beta4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: OUTER JOIN performance regression remains in 8.3beta4  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
>>> On Fri, Jan 4, 2008 at  4:51 PM, in message
<477E640F.EE98.0025.0@wicourts.gov>, "Kevin Grittner"
<Kevin.Grittner@wicourts.gov> wrote:

>  keyEventSeqNo  | integer       |

>         COALESCE(
>         CASE
>             WHEN d."eventType" IS NOT NULL THEN d."keyEventSeqNo"::smallint
>             ELSE b."keyEventSeqNo"::smallint
>         END::integer, 0) AS "keyEventSeqNo",
That seems like a potential problem.  I should probably be casting
the literal of zero to "HistSeqNoT".
-Kevin




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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: OUTER JOIN performance regression remains in 8.3beta4
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: OUTER JOIN performance regression remains in 8.3beta4