>
> maybe i'm doing something wrong here:
>
> CREATE TABLE samples
> (
> mark abstime,
> subnetinet,
> bytes_in float8,
> bytes_out float8
> );
> CREATE INDEX samples_mark ON samples (mark);
>
> --- fill it with lots and lots of data
>
> BEGIN WORK;
> DECLARE mycurs CURSO
> 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 mar