Newbie: execute function error! - Mailing list pgsql-sql

From John GM
Subject Newbie: execute function error!
Date
Msg-id 981uer$1vu3$1@news.tht.net
Whole thread Raw
Responses Re: Newbie: execute function error!  (dev@archonet.com)
List pgsql-sql
I created a sample function:

CREATE FUNCTION concat_text (text, text) RETURNS text AS '
BEGIN   RETURN $1 || $2;
END; '
LANGUAGE 'plpgsql';


The creation was fine.  But when I execute the function with : select
concat('a', 'b');

I get the error:

NOTICE:  plpgsql: ERROR during compile of concat_text near line 1
"RROR:  parse error at or near "

What did I do wrong?

Thanks!




pgsql-sql by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: No Documentation for to_char(INTERVAL, mask)
Next
From: Michelle Murrain
Date:
Subject: Re: [GENERAL] Re: MySQLs Describe emulator!