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

From: Christoph Berg <myon(at)debian(dot)org>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
Date: 2025-03-25 17:58:40
Message-ID: Z-Lu0EB5R2mIovAF@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2025-03-25 20:21:34 Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
Previous Message Christophe Pettus 2025-03-25 17:13:35 Re: Replication slot WAL reservation