concatenating two text attributes

I'd like to do something like

SELECT strcat(foo,bar) FROM test;

or

SELECT foo+bar FROM test;

where test is

CREATE TABLE test (foo char(20), bar char(20));
INSERT INTO test (foo,bar) VALUES ('foo','bar');

Of course it seems like it'd be easy enough to write a PL/TCL funcion
to do this (or pick your favorite PL here). But before I do that I'd
just like to check if PostgreSQL (or generic SQL for that matter)
provides a means of doing that. I've look through te docs, but I
don't see anything like it. Just seems so intuitive though.

So, is anyone aware of a way to to this that doesn't require
scripting? (Sorry if this is a newbie question -- I have looked).

--
Karl DeBisschop <kdebisschop(at)alert(dot)infoplease(dot)com>
617.832.0332 (Fax: 617.956.2696)

Information Please - your source for FREE online reference
http://www.infoplease.com - Your Ultimate Fact Finder
http://kids.infoplease.com - The Great Homework Helper