Alexander Korotkov comments

Results 88 comments of


                                            Alexander Korotkov

jsquery_in/out compatibility issue

I think inner parenthesis are not required for NOT. Committed fix to master branch. Please, check.

Building for Ubuntu 14.04

Requirement of PostgreSQL development package was mentioned in README. I've recently added flex and bison requirement into README. Could you, please, tell which version of flex and bison did you...

Fatal error install - ubuntu

Could you try to clean and make again? ``` make USE_PGXS=1 clean make USE_PGXS=1 ``` Also could you show output of following commands? ``` bison --version flex --version ```

LIKE expressions for string

Hi, In your example, "path" is field in json object or it's path with object keys like "key1.key2.key3.value"?

LIKE expressions for string

In our current semantics of \* ``` "gender".* ilike "mal%" ``` would be ``` "gender" ( "text" ILIKE "mal%" | "coding" .# ( "code" ilike "mal%" | "display" ilike "mal%...

Question: jsquery in order by

Unfortunately, that's not possible to this in GIN indexes yet. You could create btree expression index on js->'animal_counts'->'tigers'.

Building on Windows

Could you try this instruction? https://wiki.postgresql.org/wiki/Building_and_Installing_PostgreSQL_Extension_Modules#Windows_with_Microsoft_Visual_Studio

make USE_PGXS=1 install,fail

Please post contents of "/usr/local/src/imgsmlr-master/regression.diffs"

Ad hoc search using RUM indexes

BTW, in spite of GIN weights are present in RUM index posting lists and could be used for filtering within the index.

ERROR: index row size 1648 exceeds maximum 1336 for index "..."

Please, try commit 58fee2882c75aceccf2366dfe097da97e67ab9a3.