Skip site navigation (1) Skip section navigation (2)

BUG #6181: concat_ws() incompatibility with MySQL

From: "Itagaki Takahiro" <itagaki(dot)takahiro(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6181: concat_ws() incompatibility with MySQL
Date: 2011-08-29 11:42:45
Message-ID: 201108291142.p7TBgjiJ027349@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      6181
Logged by:          Itagaki Takahiro
Email address:      itagaki(dot)takahiro(at)gmail(dot)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'], '/')

Responses

pgsql-bugs by date

Next:From: Kevin GrittnerDate: 2011-08-29 12:49:42
Subject: Re: the '::' cast doesn't work in the FROM clause
Previous:From: Alexey KlyukinDate: 2011-08-29 11:20:56
Subject: the '::' cast doesn't work in the FROM clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group