<div class="moz-cite-prefix">On 02/25/2013 08:54 AM, Mike Toews wrote:<br /></div><blockquote
cite="mid:CAM2FmMowmELKBBEmiFfP0ax9-8zRPF-Be2mV_htRUw7RUM7o0w@mail.gmail.com"type="cite">On 25 February 2013 12:48,
CraigRinger <<a href="mailto:craig@2ndquadrant.com" moz-do-not-send="true">craig@2ndquadrant.com</a>> wrote:<br
/>> However, the thing I want most couldn't be provided by this patch<br /> > because it seems to be a deeper
serverlimitation: the ability to get<br /> > typmod data from calculation results like<br /> ><br /> >
NUMERIC(8,3)'11.131' + NUMERIC(8,3) '12.123'<br /><br /> But is the derived typmod always available?<br
/></blockquote><br/> No, it usually isn't. I doubt this patch can provide that information because the server doesn't
keeptrack of derived typmods through a lot of internal operations. If it can I'll jump for joy.<br /><br /> I was just
pointingout that you can already get something similar to this patch's effects with pg_typeof . It's a nice convenience
notto have to wrap everything in pg_typeof, though, and this patch seems useful.<br /><pre class="moz-signature"
cols="72">--Craig Ringer <a class="moz-txt-link-freetext"
href="http://www.2ndQuadrant.com/">http://www.2ndQuadrant.com/</a>PostgreSQLDevelopment, 24x7 Support, Training &
Services</pre>
