Re: [SQL] using 'zoneinfo' to manipulate dates ...

2005-06-25 Thread Alvaro Herrera
On Sun, Jun 26, 2005 at 12:24:53AM -0300, Marc G. Fournier wrote: > > Does anyone have a 'table of timezones' that could be used to "localize" > as part of a query? > > For instance, something like: > > SELECT date > FROM table > WHERE ( time || ' ' || ( SELECT timezone >

[SQL] using 'zoneinfo' to manipulate dates ...

2005-06-25 Thread Marc G. Fournier
Does anyone have a 'table of timezones' that could be used to "localize" as part of a query? For instance, something like: SELECT date FROM table WHERE ( time || ' ' || ( SELECT timezone FROM zones WHERE id = table.timezone )) = '2004-

Re: [SQL] people who buy A, also buy C, D, E

2005-06-25 Thread Jan Wieck
On 6/24/2005 11:35 PM, Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The goal of my query is: given a book, what did other people who bought this book also buy? I plan the list the 5 most popular such books. This sounds very much like one of the congestion problem