Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-30 Thread Tom Lane
Sam Mason [EMAIL PROTECTED] writes: Sounds as though you need some sort of type inference algorithm. There are quite a few decidable ones around, the one by Hindley-Milner being very popular/common. Decidable means you get the correct answer out in a reasonable amount of time or it fails,

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-30 Thread Sam Mason
[ I'm not very sure of my WITH RECURSIVE syntax, so please excuse any mistakes ] On Fri, Nov 30, 2007 at 01:00:27PM +, Gregory Stark wrote: Hopefully at the cte call sites we'll be able to gin up enough information to fill in the subquery information enough for the planner above to work

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-30 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: I could imagine problems the planner would have to deal with though, such as what type is bogon in this query? WITH RECURSIVE x(bogon) AS (select bogon from x) select * from x; Just a note --- that's not the

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-30 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: I could imagine problems the planner would have to deal with though, such as what type is bogon in this query? WITH RECURSIVE x(bogon) AS (select bogon from x) select * from x; Just a note --- that's not the planner's problem, either. Semantic

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-30 Thread Gregory Stark
Tatsuo Ishii [EMAIL PROTECTED] writes: We decided to start working on WITH RECURSIVE too. Currently one of our engineers is about to start to look at what has been done and what is remaining. We hope to work together with you! Here's the original message where I posted what I think we need

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-30 Thread Tatsuo Ishii
Hubert FONGARNAND [EMAIL PROTECTED] writes: Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné, nous vous remercions de bien vouloir le supprimer et en aviser immédiatement l'expéditeur. Toute

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-27 Thread Andrew Dunstan
Hubert FONGARNAND wrote: We are using the CONNECT BY patch made by Evgen Potemkin on PostGreSQL 8.2... It works like a charm with very high performances. But now, we are looking for the 8.3 release... Evgen Potemkin has stopped to answer about this patch (it's quite normal, he's working

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-27 Thread Gregory Stark
Hubert FONGARNAND [EMAIL PROTECTED] writes: Ce message et les éventuels documents joints peuvent contenir des informations confidentielles. Au cas où il ne vous serait pas destiné, nous vous remercions de bien vouloir le supprimer et en aviser immédiatement l'expéditeur. Toute utilisation de

Re: [HACKERS] PostGreSQL and recursive queries...

2007-11-27 Thread Hubert FONGARNAND
Le mardi 27 novembre 2007 à 10:00 -0500, Andrew Dunstan a écrit : Hubert FONGARNAND wrote: We are using the CONNECT BY patch made by Evgen Potemkin on PostGreSQL 8.2... It works like a charm with very high performances. But now, we are looking for the 8.3 release... Evgen Potemkin