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

[Thiemo Kellner]

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?