Best way to do this query..
| От | Henry Ortega |
|---|---|
| Тема | Best way to do this query.. |
| Дата | |
| Msg-id | 2bffcc330608251316g6ed00710u6e43b243800c6087@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Best way to do this query..
Re: Best way to do this query.. |
| Список | pgsql-sql |
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 по дате отправления: