Postgres Pro
Downloads
Home   >   mailing lists

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

From Thiemo Kellner
Subject Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
Date
Msg-id 8a694e38-e10c-4ce8-8d4c-8ac0bd8f1b75@gelassene-pferde.biz
Whole thread Raw
In response to Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?  (Christoph Berg <myon@debian.org>)
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Christoph Berg
Date:
Subject: Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
Next
From: Phillip Diffley
Date:
Subject: Re: Replication slot WAL reservation