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
>
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-
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