GIN theory

2022-06-03 Thread huangning...@yahoo.com
Hi: I want to know the time that create a gin index for a array, or some theory about gin index? Thanks

Parallel not working

2022-05-17 Thread huangning...@yahoo.com
Hi: I write a  C function, the function is as follows: create function st_geosotgrid(geom geometry, level integer) returns geosotgrid[] immutable strict parallel safe language c as $$ begin -- missing source code end; $$; At the same time, I set the relevant parameters: force_pa

GIN index

2022-01-25 Thread huangning...@yahoo.com
Hi:I created a new variable-length data type, and now I want to create a GIN index for it. According to the rules of GIN index, I created three functions: extractValue, extractQuery, and compare. I made sure that the return value of the first two functions is the address of the array, but when u

Re: develop a extension with cpp?

2021-11-03 Thread huangning...@yahoo.com
Thank you.  On Wednesday, November 3, 2021, 06:20:18 AM GMT+8, Dmitry Igrishin wrote: вт, 2 нояб. 2021 г. в 20:12, huangning...@yahoo.com : > > Hi >    if i can develop a extension with cpp language? Sure, you can. Please, see example -- https://github.com/dmitigr/pgnso

develop a extension with cpp?

2021-11-02 Thread huangning...@yahoo.com
Hi    if i can develop a extension with cpp language? regards!

create a new GIN index for my own type

2021-10-04 Thread huangning...@yahoo.com
Hi:  I created a new data type, and then I wanted to create a GIN index for it, but when I created the index, the program would crash 。  The version of postgresql is 9.6。 The following is part of the code, and I also refer to the code of intarray. ```sqlCREATE OR REPLACE FUNCTION geomgrid_in(cst