PostgreSQL Bugs - Re: [SQL] could not devise a query plan

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: [SQL] could not devise a query plan

Szűcs Gábor

2005-05-24, 7:24 am

Dear Gnanavel,

(please reply to the lists...)

Indeed it works!

Still, I think it's a bug.

As for this solution being a workaround, it's a bit of pain, since the
subselect names (effectively, the included subselects) are not constant.

As for my workaround, I used a condition to not include the last WHERE
clause in the query when the inner WHERE clauses are present (since it does
nothing).

--
G.

On 2005.05.24. 13:14, Gnanavel Shanmugam wrote:[color=darkred
]
> replace
> WHERE a+b = 3;
> with
> WHERE aa.a+aa.b = 3;
>
> (or)
> WHERE bb.a+bb.b = 3;
>
>
> with regards,
> S.Gnanavel
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sponsored Links