PostgreSQL 15: ERROR: operator is not unique: unknown || double precision
1
vote
1
answer
2264
views
we are using a PostgreSQL version 15 and have added 13 conversions from this blog entry:
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
However, only now we have the problem when we want to join a string e.g. with a number:
SELECT 'Test: '||123.45 FROM TEST
The SQL returns the error here:
> ERROR: operator is not unique: unknown || integer
If we remove the conversion "double percision --> text", the SQL works. However, we need the conversions elsewhere.
We actually want to avoid using
CAST()
, ::VARCHAR
or ::TEXT
, as this affects a large number of queries.
Does anyone have any ideas on how we can solve the problem?
Asked by Athris
(21 rep)
Nov 23, 2023, 12:33 PM
Last activity: Nov 23, 2023, 03:12 PM
Last activity: Nov 23, 2023, 03:12 PM