Postgres Pro
Downloads
Home   >   mailing lists

Best way to do this query.. - Mailing list pgsql-sql

From Henry Ortega
Subject Best way to do this query..
Date
Msg-id 2bffcc330608251316g6ed00710u6e43b243800c6087@mail.gmail.com
Whole thread Raw
Responses Re: Best way to do this query..  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: Best way to do this query..  (Richard Broersma Jr <rabroersma@yahoo.com>)
List pgsql-sql
Tree view 
I have the following:<br /><br />name      effective         tstamp                                   rate<br
/>John      01-01-2006     2005-12-07 13:39:07.614945    115.00<br />John       01-16-2006     2006-01-07
13:39:07.614945    125.00<br /> John       01-16-2006     2006-01-09 15:13:04.416935    1885.00<br /><br />I want the
outputto be:<br />name      effective         end_date        rate<br /> John       01-01-2006     01-15-2006   
115.00<br/> John       01-16-2006                         1885.00<br /><br />What is the best way to do this? This is
ona huge table and what I<br />have right now is quite slow. Any ideas?<br /><br /><br />

pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: RES: Lock Problem
Next
From: Andrew Sullivan
Date:
Subject: Re: Best way to do this query..