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

2011-08-29 Thread 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_str

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

2011-08-29 Thread 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