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 Christoph Berg
Subject Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
Date
Msg-id Z-Lu0EB5R2mIovAF@msg.df7cb.de
Whole thread Raw
In response to Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Replication slot WAL reservation
Next
From: Thiemo Kellner
Date:
Subject: Re: How to pass a list of locations (longitude, latitude) to a PostgreSQL/PostGIS stored function?