* Peter Eisentraut <peter_e@gmx.net> [000305 06:44] wrote:
> Table schema? Data?
*smacks head on keyboard* ... Ed Loehr pointed out a mistake:
>
> Alfred Perlstein writes:
>
> > select
> > raw.ipaddress,
> > formatted.ipaddress
> > from
> > raw ,
> > formatted
> > where
> > raw.stat_date < '2000-02-26 02:00:24-08'
> > AND
> > formatted > '2000-02-26 02:00:24-08'::datetime - '24 hour'::timespan
-----^^^^^^^^^^ fieldname? :)
> > AND
> > raw.ipaddress = formatted.ipaddress;
> >
> > gives this:
> >
> > NOTICE: unknown node tag 704 in fireRIRonSubselect()
> > NOTICE: Node is: { IDENT "formatted" }
> > NOTICE: unknown node tag 704 in modifyAggrefQual()
> > NOTICE: Node is: { IDENT "formatted" }
> > ERROR: copyObject: don't know how to copy 704
However this error message is a bit more scary than it needs to be, no? :)
thanks,
-Alfred