[postgis-devel] Function Removal

Bruce Rindahl bruce.rindahl at gmail.com
Thu Dec 17 16:22:07 PST 2020


> Requiring SRID to be named seems more reasonable - but it still leaves
> open the possibility of confusion with an ordinate value, right?
>

Correct.

CREATE OR REPLACE FUNCTION public.st_makepoint(
x double precision,
y double precision,
srid integer)
    RETURNS geometry
    LANGUAGE 'sql'
    COST 100
    IMMUTABLE STRICT PARALLEL SAFE
AS $BODY$
SELECT public.st_setsrid(st_makepoint($1, $2),$3)
$BODY$;

overloads the function.

select st_asEWKT(st_makepoint(1,2,4326))    gives SRID=4326;POINT(1 2)
while
select st_asEWKT(st_makepoint(1,2,4326.0))     gives POINT(1 2 4326)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20201217/f3bb2814/attachment.html>


More information about the postgis-devel mailing list