Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?

[Thiemo Kellner <thiemo@xxxxxxxxxxxxxxxxxxxx>]

El 25-03-25 a las 18:58, Christoph Berg escribió:
> Re: Tom Lane
> > You might be best advised to create a composite
> > type like "location (long bigint, lat bigint)" and use an array of
> > that.
> Or use the geometry types from PostGIS, since you are probably going
> to do geo lookups on these points anyway.
>
> Christoph
Why is pure SQL not an option instead of a procedure/function?