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

From: Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
Date: 2025-03-25 20:21:34
Message-ID: 8a694e38-e10c-4ce8-8d4c-8ac0bd8f1b75@gelassene-pferde.biz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Phillip Diffley 2025-03-25 21:27:58 Re: Replication slot WAL reservation
Previous Message Christoph Berg 2025-03-25 17:58:40 Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?