On Fri, Dec 13, 2013 at 3:53 PM, Martijn van Oosterhout <kleptog@svana.org> wrote: > > On Thu, Dec 12, 2013 at 08:50:26PM -0200, Fabrízio de Royes Mello wrote: > > On Thu, Dec 12, 2013 at 3:11 PM, Pavel Stehule <pavel.stehule@gmail.com>wrote: > > > > > Hello > > > > > > this patch try to complete a set of functions make_date and make_timestamp. > > > > > > > > Could we have the 'make_timestamptz' function too? > > Wouldn't this just be: > > SELECT make_timestamp(...) at time zone 'foo'; > > (assuming make_timestamp actually returns a timestamp and not a > timestamptz). > > or do you mean something else? >
Your example will convert the timestamp into time zone defined by 'at time zone...'.
I think the goal of the "make_date/time/timestamp" function series is build a date/time/timestamp from scratch, so the use of 'make_timestamptz' is to build a specific timestamp with timezone and don't convert it.
