Re: [GENERAL] huge backend processes

> if i revert my code to (note: less the DATE_PART conversion):
>
> DECLARE mycurs CURSOR FOR
>    SELECT mark, subnet, bytes_in, bytes_out
>    FROM samples
>    WHERE mark >= 'epoch or another date'::abstime;
>
> it works fine.

as a followup, if i use:

DECLARE mycurs CURSOR FOR
   SELECT mark::int8, subnet, bytes_in, bytes_out
   FROM samples
   WHERE mark >= 'epoch or another date'::abstime;

it works fine as well.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]