Re: [GENERAL] Composite fields and the query planner

2013-05-09 Thread Steve Rogerson
On 05/05/13 15:06, Tom Lane wrote: Steve Rogerson writes: I'm seeing a problem with the query planner not doing what's expected, and I think it is because we are using composite fields. Here is a stripped down example. create type type1 as ( part1 varchar, part2 varchar); create table table1 (f

Re: [GENERAL] Composite fields and the query planner

2013-05-07 Thread Steve Rogerson
On 05/05/13 15:06, Tom Lane wrote: Steve Rogerson writes: I'm seeing a problem with the query planner not doing what's expected, and I think it is because we are using composite fields. Here is a stripped down example. I tested this example in HEAD and 9.0.x and didn't see any particular prob

Re: [GENERAL] Composite fields and the query planner

2013-05-05 Thread Tom Lane
Steve Rogerson writes: > I'm seeing a problem with the query planner not doing what's expected, and I > think it is because we are using composite fields. Here is a stripped down > example. > create type type1 as ( part1 varchar, part2 varchar); > create table table1 (field1 type1, field2 varch