CONCAT function not working in postgres 10

Question

select CONCAT(name, desc) from table;

gives the below error

 ERROR:  syntax error at or near "desc"
 LINE 1: select CONCAT(name, desc) from theme;
                            ^
 SQL state: 42601
 Character: 21

the same query works on sqlserver,hana and oracle? Any help would be appreciated

user330315 · Accepted Answer · 2018-09-07 09:43:44Z

2

desc is a reserved keyword, you have to quote it:

select CONCAT(name, "desc") 
from the_table

If you pay close attention to the ^ in the error message it points exactly to the desc part indicating that this is the problem, not the concat() function.

answered Sep 7, 2018 at 9:43

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

CONCAT function not working in postgres 10

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related