Martijn van Oosterhout schrieb:
Did you not find this during your searching?
http://archives.postgresql.org/pgsql-general/2008-03/msg00995.php
and followups.
Have a nice day,
no i didnt found it in google.
now everything is working and as excpected:
EXPLAIN ANALYSE big query
Runtime 45
On Tue, May 06, 2008 at 03:37:57PM +0200, Daniel Schuchardt wrote:
> Hey Matijn,
>
> it simply does not work. Every created CAST will crash with the '||'
> operator.
>
> Thnx for your comments,
Did you not find this during your searching?
http://archives.postgresql.org/pgsql-general/2008-03/ms
Martijn van Oosterhout schrieb:
On Tue, May 06, 2008 at 02:09:30PM +0200, Daniel Schuchardt wrote:
*SCDS=# SELECT 1||'~'||1;
ERROR: operator is not unique: integer || unknown at character 9
HINT: Could not choose a best candidate operator. You might need to add
explicit type casts.
LINE 1
On Tue, May 06, 2008 at 02:09:30PM +0200, Daniel Schuchardt wrote:
> *SCDS=# SELECT 1||'~'||1;
> ERROR: operator is not unique: integer || unknown at character 9
> HINT: Could not choose a best candidate operator. You might need to add
> explicit type casts.
> LINE 1: SELECT 1||'~'||1;
Check th
If i use this script
http://people.planetpostgresql.org/peter/index.php?/archives/18-Readding-implicit-casts-in-PostgreSQL-8.3.html
in PostgreSql 8.3 to reactivate autocast i get the following problems:
*without autocast* script (i learned that 8.3 does autocast if one of
the || parameters is T
