Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
I will try to provide one, but it will have to wait till weekend. Cheers, Andrei On Sep 18, 2012, at 2:05 PM, Tom Lane wrote: > Andrei Tchijov writes: >> SQL (Please let me know if you need definitions for other tables/views >> involved): > > What we need is

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
No. But the form for entering bugs is not very ... sophisticated. Thanks for pointing me to this wiki, I will re-submit properly. Cheers, Andrei On Sep 17, 2012, at 11:55 PM, Tom Lane wrote: > and...@tchijov.com writes: >> In a view (can provide source upon request) where condition

Re: [BUGS] BUG #7552: where clause gets ignored on one of view fields

2012-09-18 Thread Andrei Tchijov
Hi, I have a view (see SQL at the end of this e-mail). Query like following works without any problems on 9.0 and 9.1. select * form v_jobs where rdms_job_number = 41771; However, on 9.2 this query acts as it is select * form v_jobs; It seems that this problem occur only