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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services