From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Dustin Sallings <dustin(at)spy(dot)net> |
Subject: | view problem |
Date: | 1998-05-16 17:44:14 |
Message-ID: | Pine.BSF.3.96.980516144347.287G-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
===================================================================
This message has been sent to a DEAD mailing list, and subsequently
reforwarded to the proper one: pgsql-interfaces(at)postgresql(dot)org
===================================================================
Hey, can someone tell me why this happens and/or possibly a better way
to do it?:
misc=> create view fifteen as
misc-> select * from rstat where
misc-> (
misc-> time>datetime(now())-'1 minute'::timespan and
misc-> time<datetime(now())+'1 minute'::timespan
misc-> ) or
misc-> (
misc-> time>datetime(now())-'16 minutes'::timespan and
misc-> time<datetime(now())-'15 minutes'::timespan
misc-> )
misc-> ;
ERROR: DefineQueryRewrite: rule plan string too big.
I'm taking samples of rstat, and I want to be able to pull out one
current sample, and one sample from fifteen minutes ago. I've tried this with
between, and I tried it with the date truncation stuff, just won't take my
view. I also tried making a function that did something similar, 'cept it
produces a strange output, (just returns OIDs?). TIA
--
SA, software.net My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 1998-05-16 22:22:03 | field delimiter... |
Previous Message | The Hermit Hacker | 1998-05-15 20:14:31 | Re: [GENERAL] Distributed Database with PostgreSQL |