"Alvaro Herrera" <[EMAIL PROTECTED]> writes: > Hmm, if we do that, how would the system resolve something like this? > > select 1000 + 1000
Well we have the same problem with 'foo' || 'bar'. The question I think is whether the solution there scales to having two different fallback types. > There would be no clue as to what + operator to pick, since both > operands are unknown. This is in fact what happens today with > > alvherre=# select '100' + '100'; > ERROR: operator is not unique: unknown + unknown at character 14 > HINT: Could not choose a best candidate operator. You might need to add > explicit type casts. > STATEMENT: select '100' + '100'; Perhaps we could kill two birds with one stone... -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
