Re: patch: make_timestamp function

There are also timezones off by 15 minutes (although only a few, mainly
Nepal).

The only integer representation I've ever seen is in 15 minutes units.

http://www.timeanddate.com/time/time-zones-interesting.html

On Tue, Dec 17, 2013 at 12:33 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:

> On Tue, Dec 17, 2013 at 06:07:38PM +0100, Pavel Stehule wrote:
> > Hello
> >
> >
> > 2013/12/17 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> >
> >
> >
> >
> > 2013/12/17 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> >
> > Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> writes:
> > > Yeah, I think a constructor should allow a text timezone.
> >
> > Yes. I think a numeric timezone parameter is about 99% useless,
> > and if you do happen to need that behavior you can just cast the
> > numeric to text no?
> >
> >
> > yes, it is possible. Although fully numeric API is much more
> consistent.
> >
> >
> >
> > I was wrong - there are timezones with minutes like Iran = '1:30';
> >
> > so int in hours is bad type - so only text is probably best
>
> I think India is the big non-integer timezone offset country:
>
> http://www.timeanddate.com/worldclock/city.html?n=176
> UTC/GMT +5:30 hours
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + Everyone has their own god. +
>
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>