<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Thank you!<br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On Apr 21, 2018, at 6:42 PM, Olivier Leprêtre <<a href="mailto:o.lepretre@gmail.com" class="">o.lepretre@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div class="WordSection1" style="page: WordSection1; caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;"><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(31, 73, 125);" class="">this works : SELECT ('name', ST_GeogFromText('POINT(121.560800 29.901200)'))::place;<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(31, 73, 125);" class="">Olivier<o:p class=""></o:p></span></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span lang="EN-US" style="font-size: 10pt; font-family: Verdana, sans-serif; color: rgb(31, 73, 125);" class=""><o:p class=""> </o:p></span></div><div class=""><div style="border-style: solid none none; border-top-width: 1pt; border-top-color: rgb(181, 196, 223); padding: 3pt 0cm 0cm;" class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><b class=""><span style="font-size: 10pt; font-family: Tahoma, sans-serif;" class="">De :</span></b><span style="font-size: 10pt; font-family: Tahoma, sans-serif;" class=""><span class="Apple-converted-space"> </span>postgis-users [<a href="mailto:postgis-users-bounces@lists.osgeo.org" class="">mailto:postgis-users-bounces@lists.osgeo.org</a>]<span class="Apple-converted-space"> </span><b class="">De la part de</b><span class="Apple-converted-space"> </span>Glen Huang<br class=""><b class="">Envoyé :</b><span class="Apple-converted-space"> </span>samedi 21 avril 2018 12:19<br class=""><b class="">À :</b><span class="Apple-converted-space"> </span><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class=""><b class="">Objet :</b><span class="Apple-converted-space"> </span>[postgis-users] How to specify PostGIS geography value in a composite type literal?<o:p class=""></o:p></span></div></div></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Hi,<o:p class=""></o:p></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">I asked this question on SO (<a href="https://stackoverflow.com/questions/49954323/how-to-specify-postgis-geography-value-in-a-composite-type-literal" style="color: purple; text-decoration: underline;" class="">https://stackoverflow.com/questions/49954323/how-to-specify-postgis-geography-value-in-a-composite-type-literal</a>)<o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">but didn’t get much attention. I wonder if someone here could shed some light. <o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Here is the question:<o:p class=""></o:p></div></div><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><o:p class=""> </o:p></div></div><div class=""><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: "Times New Roman", serif; vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; caret-color: rgb(36, 39, 41);"><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">I have a custom composite type:<o:p class=""></o:p></span></p><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; max-height: 600px; word-wrap: normal; overflow: auto;" class=""><span class="kwd"><span style="font-family: inherit, serif; color: rgb(16, 16, 148); border: 1pt none windowtext; padding: 0cm;" class="">CREATE</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> TYPE place </span></span><span class="kwd"><span style="font-family: inherit, serif; color: rgb(16, 16, 148); border: 1pt none windowtext; padding: 0cm;" class="">AS</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> </span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">(</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""><o:p class=""></o:p></span></span></pre><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline;" class=""><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> name text</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">,</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""><o:p class=""></o:p></span></span></pre><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline;" class=""><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> location geography</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">(</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">point</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">,</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> </span></span><span class="lit"><span style="font-family: inherit, serif; color: rgb(125, 39, 39); border: 1pt none windowtext; padding: 0cm;" class="">4326</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">)</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""><o:p class=""></o:p></span></span></pre><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline;" class=""><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">);</span></span><span style="font-family: Consolas; color: rgb(57, 51, 24);" class=""><o:p class=""></o:p></span></pre><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: "Times New Roman", serif; vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; caret-color: rgb(36, 39, 41);"><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">I want to create a value of that type using a composite literal:<o:p class=""></o:p></span></p><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; max-height: 600px; word-wrap: normal; overflow: auto;" class=""><span class="kwd"><span style="font-family: inherit, serif; color: rgb(16, 16, 148); border: 1pt none windowtext; padding: 0cm;" class="">SELECT</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> </span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">$$(</span></span><span class="str"><span style="font-family: inherit, serif; color: rgb(125, 39, 39); border: 1pt none windowtext; padding: 0cm;" class="">"name"</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">,</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> </span></span><span class="str"><span style="font-family: inherit, serif; color: rgb(125, 39, 39); border: 1pt none windowtext; padding: 0cm;" class="">"ST_GeogFromText('POINT(121.560800 29.901200)')"</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">)$$::</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">place</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">;</span></span><span style="font-family: Consolas; color: rgb(57, 51, 24);" class=""><o:p class=""></o:p></span></pre><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: "Times New Roman", serif; vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; caret-color: rgb(36, 39, 41);"><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">This fails with:<o:p class=""></o:p></span></p><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; max-height: 600px; word-wrap: normal; overflow: auto;" class=""><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">HINT</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">:</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> </span></span><span class="str"><span style="font-family: inherit, serif; color: rgb(125, 39, 39); border: 1pt none windowtext; padding: 0cm;" class="">"ST"</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> </span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""><</span></span><span class="com"><span style="font-family: inherit, serif; color: rgb(133, 140, 147); border: 1pt none windowtext; padding: 0cm;" class="">-- parse error at position 2 within geometry</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""><o:p class=""></o:p></span></span></pre><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline;" class=""><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">ERROR</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">:</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> parse error </span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">-</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> invalid geometry</span></span><span style="font-family: Consolas; color: rgb(57, 51, 24);" class=""><o:p class=""></o:p></span></pre><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: "Times New Roman", serif; vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; caret-color: rgb(36, 39, 41);"><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">But this executes just fine:<o:p class=""></o:p></span></p><pre style="margin: 0cm 0cm 0.0001pt; font-size: 10pt; font-family: "Courier New"; background-color: rgb(239, 240, 241); vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; max-height: 600px; word-wrap: normal; overflow: auto;" class=""><span class="kwd"><span style="font-family: inherit, serif; color: rgb(16, 16, 148); border: 1pt none windowtext; padding: 0cm;" class="">SELECT</span></span><span class="pln"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class=""> ST_GeogFromText</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">(</span></span><span class="str"><span style="font-family: inherit, serif; color: rgb(125, 39, 39); border: 1pt none windowtext; padding: 0cm;" class="">'POINT(121.560800 29.901200)'</span></span><span class="pun"><span style="font-family: inherit, serif; color: rgb(48, 51, 54); border: 1pt none windowtext; padding: 0cm;" class="">);</span></span><span style="font-family: Consolas; color: rgb(57, 51, 24);" class=""><o:p class=""></o:p></span></pre><p class="MsoNormal" style="margin: 0cm 0cm 12pt; font-size: 12pt; font-family: "Times New Roman", serif; vertical-align: baseline; font-stretch: inherit; line-height: inherit; box-sizing: inherit; caret-color: rgb(36, 39, 41);"><span style="font-size: 11.5pt; font-family: Arial, sans-serif; color: rgb(36, 39, 41);" class="">I wonder what's the correct way to specify PostGIS geography value in a composite type literal?<o:p class=""></o:p></span></p><div class=""><div style="margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Thanks<o:p class=""></o:p></div></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><br class=""><table style="border-top-width: 1px; border-top-style: solid; border-top-color: rgb(211, 212, 222);" class=""><tbody class=""><tr class=""><td style="width: 55px; padding-top: 18px;" class=""><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: purple; text-decoration: underline;" class=""><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;" class=""></a></td><td style="width: 470px; padding-top: 17px; color: rgb(65, 66, 78); font-size: 13px; font-family: Arial, Helvetica, sans-serif; line-height: 18px;" class="">Garanti sans virus.<span class="Apple-converted-space"> </span><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" target="_blank" style="color: rgb(68, 83, 234); text-decoration: underline;" class="">www.avast.com</a></td></tr></tbody></table><a href="x-msg://15/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1" style="color: purple; text-decoration: underline;" class=""></a></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">postgis-users mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:postgis-users@lists.osgeo.org" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">postgis-users@lists.osgeo.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div></blockquote></div><br class=""></body></html>