On Mon, 16 Mar 1998, Thomas G. Lockhart wrote:

> > > first the concatenation with ||
> > > the test is select 'abc' || 'def'
> > > and that's not working in postgres. In other db's it's working.
> > 
> > Looks like we have a type problem here.  That type system again.
> 
> "that type system" is A Good Thing(tm).
> 
> tgl=> select 'abc' || 'def';
> ERROR:  There is more than one operator '||'
>  for types 'unknown' and 'unknown'
>  You will have to retype this query using an explicit cast

This sentence doesn't work on MySQL too, take a look:

mysql> select 'abc' || 'def';
1 row in set (0.00 sec)
+----------------+
| 'abc' || 'def' |
+----------------+
|              0 |
+----------------+
The result should be 'abcdef' not 0 !!

In response to

• Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page at 1998-03-16 17:22:20 from Thomas G. Lockhart

Responses

• Re: [HACKERS] Re: [QUESTIONS] MySQL benchmark page at 1998-03-17 23:56:31 from Luuk de Boer

pgsql-hackers by date

Next:	From: Pedro J. Lobo	Date: 1998-03-17 10:40:01
	Subject: Re: [HACKERS] Alpha initdb fixed!
Previous:	From: W. Y. LU	Date: 1998-03-17 08:52:00
	Subject: unsubscribe