<div dir="ltr">Hi All,<div><br></div><div>I want to insert FLOAT values into data of type POINT via Stored Procedure</div><div><br></div><div><b><br></b></div><div><b>My Table is</b></div><div><br></div><div><div>CREATE TABLE SCHOOL</div><div>(</div><div>ID SERIAL NOT NULL,</div><div>NAME VARCHAR(450),</div><div>GEOM point,</div><div>LON DOUBLE PRECISION,</div><div>LAT DOUBLE PRECISION,</div><div>CONSTRAINT &quot;LOI_PK&quot; PRIMARY KEY(ID)</div><div>);</div></div><div><br></div><div><br></div><div><b>My Stored Procedure is</b></div><div><br></div><div><div><br></div><div>CREATE OR REPLACE FUNCTION SP_INSERT_SCHOOL</div><div>(</div><div><span class="" style="white-space:pre">        </span>p_name varchar,</div><div><span class="" style="white-space:pre">        </span>p_lon float,</div><div><span class="" style="white-space:pre">        </span>p_lat float,</div><div><span class="" style="white-space:pre">        </span></div><div><span class="" style="white-space:pre">        </span>out p_loiID INT</div><div>)</div><div>RETURNS INT AS $$</div><div><span class="" style="white-space:pre">        </span>DECLARE</div><div><span class="" style="white-space:pre">                </span>d_geom varchar;</div><div><span class="" style="white-space:pre">        </span>BEGIN</div><div><span class="" style="white-space:pre">        </span></div><div><span class="" style="white-space:pre">                </span>RAISE NOTICE &#39;Inside Trigger&#39;;</div><div><span class="" style="white-space:pre">                </span></div><div><span class="" style="white-space:pre">                </span>d_geom = &#39;&#39;&#39;(&#39; || cast(p_lon as varchar(30)) || &#39;, &#39; || cast(p_lat as varchar(30)) || &#39;)&#39;&#39;&#39;;</div><div><span class="" style="white-space:pre">                </span></div><div><span class="" style="white-space:pre">                </span>RAISE NOTICE &#39;After geom Concat % &#39;, d_geom;</div><div><span class="" style="white-space:pre">                </span></div><div><span class="" style="white-space:pre">                </span>insert into SCHOOL</div><div><span class="" style="white-space:pre">                </span>(</div><div><span class="" style="white-space:pre">                        </span>NAME,</div><div><span class="" style="white-space:pre">                        </span>GEOM,</div><div><span class="" style="white-space:pre">                        </span>LAT,</div><div><span class="" style="white-space:pre">                        </span>LON,</div><div><span class="" style="white-space:pre">                </span>)</div><div><span class="" style="white-space:pre">                </span>values</div><div><span class="" style="white-space:pre">                </span>(</div><div><span class="" style="white-space:pre">                        </span>p_name,</div><div><span class="" style="white-space:pre">                        </span>d_geom,</div><div><span class="" style="white-space:pre">                        </span>p_lat,</div><div><span class="" style="white-space:pre">                        </span>p_lon,</div><div><span class="" style="white-space:pre">                </span>)</div><div><span class="" style="white-space:pre">                </span>RETURNING ID into p_loiID;</div><div><br></div><div><span class="" style="white-space:pre">        </span>return;  </div><div><br></div><div><span class="" style="white-space:pre">        </span>END;</div><div>$$ LANGUAGE plpgsql;</div></div><div><br></div><div><br></div><div><br></div><div><div><b>Stored Procedure call from SQL - </b></div><div><br></div><div>select SP_INSERT_LOI2(&#39;School 1&#39;,72.8771232223511,19.0543151664734);</div></div><div><br></div><div><br></div><div><br></div><div><b>Error - </b></div><div><br></div><div><div>ERROR:  column &quot;geom&quot; is of type point but expression is of type character varying</div><div>LINE 22: d_geom,</div><div>         ^</div><div>HINT:  You will need to rewrite or cast the expression.</div></div><div><br></div><div><br></div><div><br></div><div>Please help me to cast my FLOAT values into POINT type</div><div><br></div><div><br></div></div>