Re: OUTER JOIN performance regression remains in 8.3beta4 - Mailing list 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