CTED]
> Cranel. Technology. Integrity. Focus.
>
>
>
> -------(end of broadcast)---
> TIP 7: don't forget to increase your free space map settings
-
> supp_name, buyer_code, buyer_name, item_code, revision, description, po_no, pos_no,
> order_date, delivery_date, reschedule_date, reschedule_qty, ordered_qty,
> delivered_qty, backorder_qty, stock, warehouse_code, allocated, exception, run_date
> from reschedule_bak where order_date >= '01/04/2003';
> 2003-12-20 11:22:04 [1558] LOG: duration: 623.982111 sec
>
--
Ray Ontko [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
-
> TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
----------
Ray Ontko [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com
(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
>(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
----------
R
---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html
------
Ray Ontko [EMAIL PROTECTED] Phone 1.765
rectly (using create as select * from )?
Ray
----------
Ray Ontko [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko & Co. Software Consulting Services http://www.ontko.com/
---(end of broadcast)---
TIP 5: Have you checked our exten
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to [EMAIL PROTECTED] so that your
> > message can get through to the mailing list cleanly
> >
> >
>
>
>
>
> ---(end of broadcast)---
ere event_date_time >= now()::timestamp with time zone - '1 month'::interval
and event_date_time < now()::timestamp with time zone
;
NOTICE: QUERY PLAN:
Aggregate (cost=21479.33..21479.33 rows=1 width=0)
-> Seq Scan on event (cost=0.00..21337.66 rows=56665 width=0)
EXPLAIN
Ray
