| From: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Cc: | Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, Michael Paquier <michael(at)paquier(dot)xyz>, Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, David Steele <david(at)pgmasters(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Oleg Bartunov <obartunov(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Subject: | Re: jsonpath |
| Date: | 2019-01-19 23:45:10 |
| Message-ID: | CAPpHfdtq0b_g9MmDPpAOFkxXSH93TrJCkxNc5EmJktUJ0tuZtA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Jan 19, 2019 at 2:54 AM Alexander Korotkov
<a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> 1) It seems that @* and @# are not going to be supported by any
> indexes. I think we should remove these operators and let users use
> functions instead.
> 2) I propose to rename @~ operator to @@. We already use @@ as
> "satisfies" in multiple places, and I thinks this case fits too.
3) How do we calculate the "id" property returned by keyvalue()
function? It's not documented. Even presence of "id" columns isn't
documented. Standard stands that it's implementation-depended
indetifier of object holding key-value pair. The way of its
calculation is also not clear from the code. Why do we need constant
of 10000000000?
id = jb->type != jbvBinary ? 0 :
(int64)((char *) jb->val.binary.data -
(char *) cxt->baseObject.jbc);
id += (int64) cxt->baseObject.id * INT64CONST(10000000000);
------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2019-01-19 23:49:08 | Re: WIP: Avoid creation of the free space map for small tables |
| Previous Message | Tomas Vondra | 2019-01-19 23:24:05 | Re: COPY FROM WHEN condition |