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 fail

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 wor

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

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 in

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

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. To

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

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 utilisat

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 at