Postgres Concatenation

Question

I'm trying to a simple concatenation in PostgreSQL and it keeps up throwing up an error message. I don't understand what I am doing wrong here.

select concat('abcde', 'fgh');
No function matches the given name and argument types. You might need to add explicit type casts.

select concat(cast('abcde' as text), cast('fgh' as text));
No function matches the given name and argument types. You might need to add explicit type casts.

I am using Postgres version 8.4.11. Please let me know what is going on.

Check out the docs: postgresql.org/docs/8.4/static/functions-string.html — jonathan.cone
– jonathan.cone, Commented Jul 30, 2012 at 4:19
Just so you know, if you want to list functions or search them, use the psql \df command. For example, to list all functions named concat use \df concat . For all functions in the pg_catalog schema (built-in functions) use \df pg_catalog. . For all functions with names starting with concat use \df concat*. — Craig Ringer
– Craig Ringer, Commented Jul 30, 2012 at 6:42

Miki · Accepted Answer · 2013-10-08 03:25:35Z

20

The concat operator is ||, so select 'abcde' || 'fgh' should work. Also, as @jonathan.cone suggested, check out the docs.

edited Oct 8, 2013 at 3:25

answered Jul 30, 2012 at 4:29

Miki

7,2382 gold badges34 silver badges42 bronze badges

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

Comments

Craig Ringer · Accepted Answer · 2012-07-30 06:46:52Z

14

concat was added in 9.1, it doesn't exist in 8.4. As others have noted, use the || operator.

Compare the 8.4 docs to the 9.1 docs and you'll notice that the concat function isn't present in the 8.4 docs.

See that bar at the top of the docs that says "This page in other versions" ? It's really handy when you're working with an old version, or if you find a link to an old version of a page via Google and you're on a newer version. Always make sure you're looking at the docs for the right version.

It'd be nice if the tables for functions etc included a "First appeared in version " - but unfortunately they don't.

If you're ever confused about the availablilty of a function, you can use \df in psql to list and search functions.

For example, to list all functions named concat use \df concat

For all functions in the pg_catalog schema (built-in functions) use \df pg_catalog. - note the trailing period, telling psql you mean "any function within the schema pg_catalog" not "the function named pg_catalog".

For all functions with names starting with concat use \df concat*

It's a very powerful tool. The same language works when searching for schema (\dn), tables (\dt), etc.

answered Jul 30, 2012 at 6:46

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

1 Comment

Stephan Over a year ago

How does concat function automagically convert a date field to string ?

ART GALLERY · Accepted Answer · 2015-01-29 02:59:41Z

1

select 'abcde' || 'fgh';

select cast('abcde' as text) || cast('fgh' as text);

answered Jan 29, 2015 at 2:59

ART GALLERY

5502 silver badges8 bronze badges

Collectives™ on Stack Overflow

Postgres Concatenation

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related