Alvaro Herrera <alvhe...@alvh.no-ip.org> writes: > I am not sure why it would be valid to list two literals in the values > but not one.
The discrepancy seems to be because transformAExprIn uses a different type resolution method when there's more than one non-Var in the RHS. Maybe we should apply select_common_type even when there's only one RHS non-Var, even though we don't want to use a ScalarArrayOpExpr? Curious that it's acted like this since 8.2 and nobody complained. 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