Andrew Dunstan <andrew@dunslane.net> writes:
> On 07/18/2012 03:18 PM, Merlin Moncure wrote:
>> there are no null fields, right? if the last field is sometimes null
>> you'd see that (you probably ruled that out though). when you say
>> 'sometimes', do you mean for some rows and not others? or for some
>> queries?
> No, the inner query has two fields.
> It happens for all rows, but not for all two-field-resulting queries as
> q. I'm trying to find a simple case rather than the rather complex query
> my customer is using.
I'm wondering about a rowtype with a third, dropped column.
regards, tom lane