| From: | Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl> |
|---|---|
| To: | TJ <tj(at)nospam(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timezone locale fun |
| Date: | 2002-11-07 16:33:57 |
| Message-ID: | 3DCA95F5.2070107@oli.tudelft.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2002-11-07 16:38:06 | Re: [SQL] Problem: Referential Integrity Constraints lost |
| Previous Message | Richard Huxton | 2002-11-07 16:29:51 | Re: licenses & price? |