On Fri, Dec 13, 2013 at 3:53 PM, Martijn van Oosterhout <klep...@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.steh...@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. Regards, -- Fabrízio de Royes Mello Consultoria/Coaching PostgreSQL >> Timbira: http://www.timbira.com.br >> Blog sobre TI: http://fabriziomello.blogspot.com >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello >> Twitter: http://twitter.com/fabriziomello