Re: patch: make_timestamp function

<div dir="ltr"><div class="gmail_extra"><br />On Fri, Dec 13, 2013 at 3:53 PM, Martijn van Oosterhout <<a
href="mailto:kleptog@svana.org">kleptog@svana.org</a>>wrote:<br />><br />> On Thu, Dec 12, 2013 at 08:50:26PM
-0200,Fabrízio de Royes Mello wrote:<br /> > > On Thu, Dec 12, 2013 at 3:11 PM, Pavel Stehule <<a
href="mailto:pavel.stehule@gmail.com">pavel.stehule@gmail.com</a>>wrote:<br/>> ><br />> > > Hello<br
/>>> ><br />> > > this patch try to complete a set of functions make_date and make_timestamp.<br />
>> ><br />> > ><br />> > Could we have the 'make_timestamptz' function too?<br />><br />>
Wouldn'tthis just be:<br />><br />> SELECT make_timestamp(...) at time zone 'foo';<br /> ><br />> (assuming
make_timestampactually returns a timestamp and not a<br />> timestamptz).<br />><br />> or do you mean
somethingelse?<br />><br /><br /></div><div class="gmail_extra">Your example will convert the timestamp into time
zonedefined by 'at time zone...'.<br /><br /></div><div class="gmail_extra">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'
isto build a specific timestamp with timezone and don't convert it.<br /></div><div class="gmail_extra"><br
/></div><divclass="gmail_extra">Regards,<br /><br /></div><div class="gmail_extra">--<br />Fabrízio de Royes Mello<br
/>Consultoria/CoachingPostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/> >> Blog sobre TI: <a
href="http://fabriziomello.blogspot.com">http://fabriziomello.blogspot.com</a><br/>>> Perfil Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/> >> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a></div></div>