Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tx8Y9-003TwT-RS
	for pgsql-general@arkaria.postgresql.org; Tue, 25 Mar 2025 17:58:53 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1tx8Y8-007leX-0E
	for pgsql-general@arkaria.postgresql.org; Tue, 25 Mar 2025 17:58:52 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <cb@df7cb.de>)
	id 1tx8Y7-007leO-M2
	for pgsql-general@lists.postgresql.org; Tue, 25 Mar 2025 17:58:51 +0000
Received: from mout-p-101.mailbox.org ([2001:67c:2050:0:465::101])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <cb@df7cb.de>)
	id 1tx8Y5-0015bf-1s
	for pgsql-general@postgresql.org;
	Tue, 25 Mar 2025 17:58:50 +0000
Received: from smtp102.mailbox.org (smtp102.mailbox.org [IPv6:2001:67c:2050:b231:465::102])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256)
	(No client certificate requested)
	by mout-p-101.mailbox.org (Postfix) with ESMTPS id 4ZMd2T5WCxz9snP;
	Tue, 25 Mar 2025 18:58:41 +0100 (CET)
Date: Tue, 25 Mar 2025 18:58:40 +0100
From: Christoph Berg <myon@debian.org>
To: Alexander Farber <alexander.farber@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: How to pass a list of locations (longitude, latitude) to a
 PostgreSQL/PostGIS stored function?
Message-ID: <Z-Lu0EB5R2mIovAF@msg.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Alexander Farber <alexander.farber@gmail.com>,
	pgsql-general <pgsql-general@postgresql.org>
References: <CAADeyWiTu2P1Y_6dPn2E+1AwSvNkwNHmT6UcFStubz0kFh9gtg@mail.gmail.com>
 <1284143.1742922449@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <1284143.1742922449@sss.pgh.pa.us>
X-Rspamd-Queue-Id: 4ZMd2T5WCxz9snP
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/Z-Lu0EB5R2mIovAF%40msg.df7cb.de>
Precedence: bulk

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