I have a table with width and height (both integers). I want to display it as are. For eg: width = 300 and height = 160. Area = 300 x 160. I am using the following query
select cast(concat(width,'x',height) as varchar(20)) from table;
or
select concat(width,'x',height) from table;
but I am getting the following error.
ERROR: function concat(character varying, "unknown", character varying) does not exist
Hint: No function matches the given name and argument types. You may need to add explicit type casts.
Can anyone tell me how to do this? Thanks
The PostgreSQL concatenate operator ( || ) is used to concatenate two or more strings and non strings.
Let's say you want to create a single Full Name column by combining two other columns, First Name and Last Name. To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.
By use + operator simply you can concatenate two or multiple text/string columns in pandas DataFrame. Note that when you apply + operator on numeric columns it actually does addition instead of concatenation.
Use ||
as per: https://www.postgresql.org/docs/current/static/functions-string.html
select width || 'x' || height from table;
Sample fiddle: http://sqlfiddle.com/#!15/f10eb/1/0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With