Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Message-ID: <8a694e38-e10c-4ce8-8d4c-8ac0bd8f1b75@gelassene-pferde.biz>
Date: Tue, 25 Mar 2025 21:21:34 +0100
MIME-Version: 1.0
Subject: Re: How to pass a list of locations (longitude, latitude) to a
 PostgreSQL/PostGIS stored function?
To: pgsql-general@lists.postgresql.org
References: 
 <CAADeyWiTu2P1Y_6dPn2E+1AwSvNkwNHmT6UcFStubz0kFh9gtg@mail.gmail.com>
 <1284143.1742922449@sss.pgh.pa.us> <Z-Lu0EB5R2mIovAF@msg.df7cb.de>
Content-Language: de-CH-frami, en-GB, it-CH, fr-CH, es-CL, es-ES
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
In-Reply-To: <Z-Lu0EB5R2mIovAF@msg.df7cb.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/8a694e38-e10c-4ce8-8d4c-8ac0bd8f1b75%40gelassene-pferde.biz>
Precedence: bulk


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?