Andrew Dunstan <and...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers