DDC-3159: CONCAT expression for PostGreSql #3919

New Issue

admin · 2026-01-22T14:31:25+01:00

admin commented

2026-01-22 14:31:25 +01:00

Originally created by @doctrinebot on GitHub (Jun 10, 2014).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user maximecolin:

For PostGreSQL, the CONCAT DQL function is translated in concatenation with || operator (which is the default behavior in AbstractPlatform class).

Is there a particular reason to not use the CONCAT PostGreSQL function instead like in MySqlPlatform ?

I ask this cause the concatenation with || operator return null if one of the part is null, whereas CONCAT function will simply ignore null values.

Originally created by @doctrinebot on GitHub (Jun 10, 2014). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user maximecolin: For PostGreSQL, the CONCAT DQL function is translated in concatenation with || operator (which is the default behavior in AbstractPlatform class). Is there a particular reason to not use the CONCAT PostGreSQL function instead like in MySqlPlatform ? I ask this cause the concatenation with || operator return null if one of the part is null, whereas CONCAT function will simply ignore null values.

admin added the Improvement label 2026-01-22 14:31:25 +01:00

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#3919