Re: timezone locale fun

TJ wrote:

> It appears that a popular solution is to temporarily change the locale
> of the postmaster.  I don't see how this could be a reasonable
> solution, assuming that once the locale is changed - every client
> would have a view of the data with the currently set locale!  If this
> were a PHP or APACHE session variable rather than a PG locale setting
> I would be much happier (btw - is that possible?!).

How about using a PHP session variable to store the timezone of the
client, and then performing selects on the data using:

SELECT field AT TIME ZONE '$client_timezone' FROM table

Jochem