Well, 33 years from now, it's a pretty safe bet that this project won't
exist. :) Or, if it does exist, that it will have been rewritten from
scratch for numerous other reasons.
(I know, I know, and 640KB ought to be enough memory for everybody.
but this time I'm right.)
On Mar 26, 2005, a
The way our app is structured, storing unixtime is the most efficient
way to get what we want.
I can't recall why I started using abstime... I started it with some
other projects years ago and was under the impression that it was the
preferred way. Maybe it was then, but isn't anymore? Maybe I'
Ben <[EMAIL PROTECTED]> writes:
> Is there a workaround I could use,
Make the column abstime instead of int, perhaps. Or better yet
timestamp. Have you considered what will happen in 2038?
regards, tom lane
---(end of broadcast)--
On Sat, Mar 26, 2005 at 12:22:51PM -0800, Ben wrote:
>
> Is there a workaround I could use, or should I stick with 7.4 for now?
The documentation discourages using abstime -- is there a reason
you're using it instead of extract(epoch from now())? That should
work in the query.
Is there a reason
Is there a workaround I could use, or should I stick with 7.4 for now?
On Mar 26, 2005, at 11:14 AM, Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
SELECT x FROM foo WHERE x < now()::abstime::integer;
ERROR: unsupported type: 23
It looks like examine_variable shouldn't be throwing away t
Michael Fuhr <[EMAIL PROTECTED]> writes:
> SELECT x FROM foo WHERE x < now()::abstime::integer;
> ERROR: unsupported type: 23
It looks like examine_variable shouldn't be throwing away the
RelabelType on the now() call ... this code is all new in 8.0
IIRC, which is why you don't see the failure in
On Sat, Mar 26, 2005 at 10:24:06AM -0700, Michael Fuhr wrote:
>
> SELECT x FROM foo WHERE x < now()::abstime::integer;
> ERROR: unsupported type: 23
\set VERBOSITY verbose
SELECT x FROM foo WHERE x < now()::abstime::integer;
ERROR: XX000: unsupported type: 23
LOCATION: convert_timevalue_to_sca
On Sat, Mar 26, 2005 at 08:25:24AM -0800, Ben wrote:
>
> gr-test=> select expires from invitecodes where expires <
> ((now())::abstime)::int4;
> ERROR: unsupported type: 23
Hmmm...
CREATE TABLE foo (x integer);
INSERT INTO foo (x) VALUES (10);
INSERT INTO foo (x) VALUES (20);
I'm attempting to upgrade to 8.0.1, and have hit my latest hurdle: an
unsupported type when I try to compare ints. Example:
gr-test=> \d invitecodes
Table "public.invitecodes"
Column | Type |Modifiers
+-
+---
