jsquery

jsquery copied to clipboard

Can not vacuum index which used jsquery in plpgsql

2

create database test; \c test create extension jsquery; create table test(j jsonb); insert into test values ('{"id":1,"test":"test"}'); CREATE OR REPLACE FUNCTION has_test(j jsonb) RETURNS boolean LANGUAGE plpgsql IMMUTABLE AS $_$...

rezonx3m

regression test failure with recent bison: syntax error, unexpected STRING_P, expecting end of file at or near """

5

With bison 3.7, some error message changed and makes the jsquery regression tests fail: ``` 607--- /tmp/autopkgtest-lxc.qv5k86ce/downtmp/build.QH8/src/expected/jsquery.out 2020-07-27 04:40:49.000000000 +0000 608+++ /tmp/autopkgtest-lxc.qv5k86ce/downtmp/build.QH8/src/results/jsquery.out 2020-07-27 04:41:38.828913000 +0000 609@@ -67,7 +67,7 @@ 610...

df7cb

Build Error: Missing jsquery_gram.h

5

Build on Ubuntu 14 and Postgres 9.5 ~/jsquery$ make USE_PGXS=1 gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -I/usr/include/mit-krb5 -fPIC...

3dmashup

> For example, jsonb document {"a": [{"b": "xyz", "c": true}, 10], "d": {"e": [7, false]}} would be decomposed into following entries: > > "a".#."b"."xyz" > "a".#."c".true > "a".#.10 > "d"."e".#.7...

Ileca

PG12 support

2

Hi, could we have a new release with PG12 support so I can update the Debian packages? Thanks!

df7cb

Here is steps for issue reproducing. Every "execute" performs successfully until 6th try. Reproduced at PostgreSQL version 10.5, jsquery version 1.1.0. ``` create extension jsquery; prepare a as (select $1::text::jsquery);...

d0d63r

Installing extension in PostgreSQL 9.6

2

Hi, is it possible to install the extension to a system running PostgreSQL 9.6? I'm trying to do it on a system where I have 'bison' version 2.7 installed but...

dmagrinya

how to select the jsonb value for particular key using JSQuery?

2

is it possible to select the value for the key in json using JSQuery? Something like this: SELECT value @@ (*.color) FROM js_test WHERE value @@ '*.color = *' Basically...

bibekdw

When using DESTDIR, the target directory is likely not yet existent, create it from the installincludes rule.

df7cb

Update in destination path for include files

1

Using variable 'includedir_server' defined in pgxs Makefile instead of hardcoded path

dmagrinya