>>> On Fri, Jan 4, 2008 at 4:51 PM, in message <[EMAIL PROTECTED]>, "Kevin Grittner" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster