Re: [GENERAL] Query planner issue

2008-09-19 Thread Andrea Moretto
Dear Richard, you are right. So Postgres takes a lot of time to get out an impossible result! The query I wrote is just a test, the concatenation is only a dummy. On 19/set/08, at 12:33, Richard Huxton wrote: Andrea Moretto wrote: I've got a table called DETAILS, the primary k

[GENERAL] Query planner issue

2008-09-19 Thread Andrea Moretto
(co_id)::text) = '010076015372010076015372'::text) Same thing if I try to trick it using a view or a stored procedure. Query planner is not easy to trick! My question is : is there a way to use the index or isn't it possible? Thanks in advance. Andrea Moretto Andrea Moretto

[GENERAL] Pgpool-II and Slony-I : query lag, sequences and stored procedures need help

2008-09-17 Thread Andrea Moretto
the pgpool mailing list, but so far no answer. Thanks in advance! Regards, Andrea Moretto Andrea Moretto [EMAIL PROTECTED] --- CONFIDENTIALITY NOTICE This message and its attachments are addressed solely to the persons above and may conta