Re: Show type in psql SELECT
| От | Mike Toews |
|---|---|
| Тема | Re: Show type in psql SELECT |
| Дата | |
| Msg-id | CAM2FmMowmELKBBEmiFfP0ax9-8zRPF-Be2mV_htRUw7RUM7o0w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Show type in psql SELECT (Craig Ringer <craig@2ndquadrant.com>) |
| Ответы |
Re: Show type in psql SELECT
|
| Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: