Re: [BUGS] BUG #6181: concat_ws() incompatibility with MySQL

[Tom Lane]

"Itagaki Takahiro"  writes:
> For query concat_ws('/', NULL, 'X'),
> PostgreSQL 9.1 returns '/X', but MySQL returns 'X'.

> I think postgres should return 'X' because of compatibility.
> Another reason is that both of the two queries below return 'X'.

> - concat_ws('/', 'X', NULL)
> - array_to_string(ARRAY[NULL, 'X'], '/')

Yeah, I think you're right.  Fortunately it's not too late to change
this without introducing backwards-compatibility issues of our own.
Will fix.

regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #6181: concat_ws() incompatibility with MySQL

[Itagaki Takahiro]

The following bug has been logged online:

Bug reference:  6181
Logged by:  Itagaki Takahiro
Email address:  itagaki.takah...@gmail.com
PostgreSQL version: 9.1 RC1 (x86)
Operating system:   Windows 7 (64bit)
Description:concat_ws() incompatibility with MySQL
Details: 

For query concat_ws('/', NULL, 'X'),
PostgreSQL 9.1 returns '/X', but MySQL returns 'X'.

I think postgres should return 'X' because of compatibility.
Another reason is that both of the two queries below return 'X'.

- concat_ws('/', 'X', NULL)
- array_to_string(ARRAY[NULL, 'X'], '/')

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs