Re: patch: make_timestamp function - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: patch: make_timestamp function
Date
Msg-id CAFj8pRB9nnWFWCPh+URK98wxvJrKChjU7i8wZz464=OjNdm0Hw@mail.gmail.com
Whole thread Raw
In response to Re: patch: make_timestamp function  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers



2013/12/17 Alvaro Herrera <alvherre@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

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: ANALYZE sampling is too good
Next
From: Robert Haas
Date:
Subject: Re: row security roadmap proposal