2013/12/17 Alvaro Herrera <alvhe...@2ndquadrant.com> > Pavel Stehule escribió: > > > but AT TIME ZONE allows double (but decimal parts is ignored quietly) > > > > postgres=# select make_time(10,20,30) at time zone '+10.2'; > > timezone > > ------------- > > 23:20:30-10 > > > > so I propose (and I implemented) a variant with int as time zone > > > > and we can (if we would) implement next one with text as time zone > > Yeah, I think a constructor should allow a text timezone. >
is there some simple way, how to parse text time zone? Regards Pavel > > -- > Álvaro Herrera http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >