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