Re: [BUGS] INSTEAD rule bug? - Mailing list pgsql-general

From Tom Lane
Subject Re: [BUGS] INSTEAD rule bug?
Date
Msg-id 10734.1058328261@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: [BUGS] INSTEAD rule bug?  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
Dmitry Tkach <dmitry@openratings.com> writes:
> It would have saved a lot of trouble if it just complained about that
> union thing right away and refuse to create the rule...

That's what happens in CVS tip.

> On a different note, I think there *is* a way to add a where clause to
> the union - that's exactly what I did in that last example - by
> converting it into a subselect...
> Can that not be done automatically for conditional rules?

Send a patch... or at least convince us it can be done ... I'm not
convinced yet.

            regards, tom lane

pgsql-general by date:

Previous
From: "Eduardo Mylonas - Externo"
Date:
Subject: Crossed Reference Query
Next
From: "jack"
Date:
Subject: question about pgsqlODBC down load