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,
[ 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
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
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
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
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
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
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
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