From: | jim(at)reptiles(dot)org (Jim Mercer) |
---|---|
To: | jim(at)reptiles(dot)org (Jim Mercer) |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] huge backend processes |
Date: | 1999-08-18 19:31:41 |
Message-ID: | m11HBQz-00080YC@mailbox.reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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(at)reptiles(dot)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 ]
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-08-18 20:24:20 | Re: [GENERAL] huge backend processes |
Previous Message | Jim Mercer | 1999-08-18 19:04:26 | huge backend processes |