>>> 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

Reply via email to