Select and functions - Mailing list pgsql-sql

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello all,

I am having a little bit of trouble here.

If I use the replace function in a select statement all works as expected.

select firstname, lastname, replace(worktelephonenumber, ' ', '') AS worktel
from contacts;

But if I use it in a before trigger the procedure fails to work.

CREATE OR REPLACE FUNCTION staging.write_work_country() RETURNS trigger AS
'DECLARE    alias_rec RECORD;BEGIN    -- Clean the phone number    NEW.worktelephonenumber =
REPLACE(NEW.worktelephonenumber,'','');    RETURN NEW;END; 
'

I get the following error:

ERROR:  parser: parse error at or near "','');

Can anyone help me please?

Thanks.

Stephen.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQE/qQiKDAwPLUWQb6sRAhNpAJ0QdVzmYdhAhFVXf06v5zACuS3y9wCfSSlS
W18AFuYb4J1le0W32uuIJto=
=xe/b
-----END PGP SIGNATURE-----