Re: [BUGS] BUG #7790: null filters in CTEs don't work

2013-01-06 Thread Tom Lane
luisa.j.franci...@gmail.com writes: > Expected output should have no nulls in it, but it does: It's not apparent to me why you think the first query shouldn't produce any rows with null parent_id? AFAICS, the recursive query will "crawl up the tree" producing a row for every parent level above th

[BUGS] BUG #7790: null filters in CTEs don't work

2013-01-06 Thread luisa . j . francisco
The following bug has been logged on the website: Bug reference: 7790 Logged by: Luisa Francisco Email address: luisa.j.franci...@gmail.com PostgreSQL version: 9.2.2 Operating system: 32-bit Windows 7 SP1 Description: Expected output should have no nulls in it, but it