Re: Setof RangeType returns

2020-12-01 Thread Patrick Handja
ache, &lower, &upper, false)); } regards, *Andjasubu Bungama, Patrick * Le ven. 27 nov. 2020 à 14:24, Tom Lane a écrit : > Patrick Handja writes: > > This is what I am doing: > > > static int > > get_range_lower(FunctionCallInfo fcinfo, RangeType *r1) &

Re: Setof RangeType returns

2020-12-01 Thread Patrick Handja
Just figured out. I think I can use RANGE_EMPTY and it will be like: > typcache =range_get_typcache(fcinfo, RangeTypeGetOid(RANGE_EMPTY)); Regards, *Andjasubu Bungama, Patrick * Le mar. 1 déc. 2020 à 16:42, Patrick Handja a écrit : > Thanks for the feedback Tom! > > >

Re: Setof RangeType returns

2020-12-09 Thread Patrick Handja
m Lane a écrit : > Patrick Handja writes: > > In my case, I do not have a range as an argument, I am receiving 2 int, > > which I am using to create a range. How can I initialize typcache in this > > case? > > You should be passing down the pointer from the outer functi

How to get Relation tuples in C function

2021-02-13 Thread Patrick Handja
Greetings! I would like to know if there is a better way to pass a relation or if the relation name (CString) as a parameter in a C function and thus be able to manipulate its tuples. The documentation is available here: https://www.postgresql.org/docs/13/xfunc-c.html#id-1.8.3.13.11. But it is not

SPI return

2021-03-04 Thread Patrick Handja
Greetings, I have spent a couple of days working on separated lib in PostgreSql, and I am facing some issues with the return of data using SPI (Server Programming Interface). I have this simple get_tuples function used in the main function foobar. My example is very simple too (Using a previously

Setof RangeType returns

2020-11-27 Thread Patrick Handja
Hello, I am currently working on Library with some specific operators to manipulate RangeType in PostGreSQL. I would like to know if it is possible to return a setof rangetype elements in Postresql in C-Language function using the suggestion like specified here: https://www.postgresql.org/docs/cur

Re: Setof RangeType returns

2020-11-27 Thread Patrick Handja
--- [4,5) [5,6) [6,7) [7,8) [8,9) [9,10) [10,11) (7 row) //========= Regards, *Andjasubu Bungama, Patrick * Le ven. 27 nov. 2020 à 04:01, Heikki Linnakangas a écrit : > On 26/11/2020 23:28, Patrick Handj