Re: [RFC] Unsigned integer support.

"Alvaro Herrera" <alvherre@commandprompt.com> 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!