operator is not unique: integer || integer

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: operator is not unique: integer || integer
Date: 2008-05-05 16:43:37
Message-ID: fvndfr$1gun$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

yeah, its clear that an upgrade from 8.1 to 8.3 is impossible for us
without a major relase.
there are to many changes so the whole project has to be rechecked.

another example:

in 83:

postgres=# SELECT 1::INTEGER||1::INTEGER;
ERROR: operator does not exist: integer || integer at character 18
HINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.

83 with autocast from peter e:

ERROR: operator is not unique: integer || integer

in 81:

postgres=# SELECT 1::INTEGER||1::INTEGER;
?column?
----------
11
(1 row)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Schuchardt 2008-05-05 16:53:20 Re: operator varchar = integer
Previous Message Daniel Schuchardt 2008-05-05 16:32:37 Re: operator varchar = integer