| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Joel Jacobson <joel(at)compiler(dot)org>, jian he <jian(dot)universality(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Do we want a hashset type? |
| Date: | 2023-06-12 13:19:08 |
| Message-ID: | e3a84833-ccbb-cc1d-a591-267444a92e09@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2023-06-12 Mo 09:00, Tomas Vondra wrote:
>
>> What was the json/jsonb story, was it ever an extension before
>> being included in core?
> I don't recall what the exact story was, but I guess the "json" type was
> added to core very long ago (before we started to push back a bit), and
> we added some SQL grammar stuff too, which can't be done from extension.
> So when we added jsonb (much later than json), there wasn't much point
> in not having it in core.
>
>
Not quite.
The json type as added in 9.2 (Sept 2012) and jsonb in 9.4 (Dec 2014). I
wouldn't call those far apart or very long ago. Neither included any
grammar changes AFAIR.
But if they had been added as extensions we'd probably be in a whole lot
more trouble now implementing SQL/JSON, so whether that was foresight or
laziness I think the we landed on our feet there.
cheers
andrew
--
Andrew Dunstan
EDB:https://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2023-06-12 13:37:35 | Re: Partial aggregates pushdown |
| Previous Message | Tomas Vondra | 2023-06-12 13:06:53 | Re: Do we want a hashset type? |