| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Add ZSON extension to /contrib/ |
| Date: | 2021-05-25 20:35:32 |
| Message-ID: | 1255760.1621974932@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> writes:
> I like the idea of the ZSON type, but I'm somewhat disappointed by its
> current limitations:
I've not read the code, so maybe this thought is completely off-point,
but I wonder if anything could be learned from PostGIS. AIUI they
have developed the infrastructure needed to have auxiliary info
(particularly, spatial reference data) attached to a geometry column,
without duplicating it in every value of the column. Seems like that
is a close analog of what's needed here.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2021-05-25 20:54:21 | Re: storing an explicit nonce |
| Previous Message | Stephen Frost | 2021-05-25 20:34:10 | Re: storing an explicit nonce |