[HACKERS] rtree_gist work

2005-07-02 Thread Janko Richter
Is currently anybody working on extending rtree_gist? I have seen, it is moved to core now. I had a look at it and because I have some experience with PGSQL's Gist API, I would do the job. Regards, Janko Richter ---(end of broa

Re: [HACKERS] rtree_gist work

2005-07-02 Thread Janko Richter
Bruce Momjian wrote: Janko Richter wrote: Is currently anybody working on extending rtree_gist? I have seen, it is moved to core now. I had a look at it and because I have some experience with PGSQL's Gist API, I would do the job. I don't think anyone is working in improving it,

Re: [HACKERS] rtree_gist work

2005-07-02 Thread Janko Richter
Tom Lane wrote: Janko Richter <[EMAIL PROTECTED]> writes: Is currently anybody working on extending rtree_gist? I have seen, it is moved to core now. I had a look at it and because I have some experience with PGSQL's Gist API, I would do the job. What changes have you got in m

Re: [HACKERS] rtree_gist work

2005-07-02 Thread Janko Richter
e hours ago. The query "point is contained in box?" is already using the GIST index in my CVS-Box. Currently, I don't see any problem. My first question was "Is anybody working on it?". Because nobody does, I would make a concept now in detail and start to implement

Re: [HACKERS] rtree_gist work

2005-07-02 Thread Janko Richter
ators. Regards, Janko Richter ___ Gesendet von Yahoo! Mail - Jetzt mit 1GB Speicher kostenlos - Hier anmelden: http://mail.yahoo.de ---(end of broa

Re: [HACKERS] Is this possible? concatenating results from a subquery

2004-04-26 Thread Janko Richter
Perhaps this helps: CREATE AGGREGATE concat ( BASETYPE = text, SFUNC= textcat, -- is function of operator 'text || text' STYPE= text, INITCOND = '' ); SELECT P.personid, P.name, concat( N.note ) AS allnotesbythisperson FROM tblperson AS P INNER JOIN tblnotes AS N ON N.per