On 25 February 2013 12:48, Craig Ringer <<a href="mailto:craig@2ndquadrant.com">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
deeperserver limitation: 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? For example, with
PostGIS:<br/><br /><font face="courier new, monospace">postgis=# SELECT g, ST_Centroid(g) INTO TEMP t<br /> postgis-#
FROM(SELECT 'POLYGON((0 0, 1 1, 0 1, 0 0))'::geometry(Polygon) g) p;<br />SELECT 1<br />postgis=# \d t<br />
Table"pg_temp_15.t"<br /> Column | Type | Modifiers<br
/>-------------+-------------------+-----------<br/> g | geometry(Polygon) |<br /> st_centroid | geometry
|<br /></font><br />-Mike