Sample Header Ad - 728x90

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