"Alvaro Herrera" <alvherre(at)commandprompt(dot)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...
Ask me about EnterpriseDB's 24x7 Postgres support!
In response to
pgsql-hackers by date
|Next:||From: Jaime Casanova||Date: 2008-07-25 16:30:21|
|Subject: Re: Column level privileges was:(Re: Extending grant insert on tables to sequences)|
|Previous:||From: Hiroshi Saito||Date: 2008-07-25 16:25:55|
|Subject: Re: Do we really want to migrate plproxy and citext intoPG core distribution?|