Joachim Wieland <[EMAIL PROTECTED]> writes:
> Getting a list of active timezones could be easily done
> with a system view but you might not want to promise its existence when you
> think about moving the whole thing to a system catalog later...
A read-only view wouldn't be a bad idea, actually, for both the
long-form TZ names and the abbreviations. It'd be easy to cons one
up the same way as our other views based on functions. Doesn't even
need to be in core, could be contrib, if there's doubts about its
usefulness.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
