From: "Stephen J. Thompson" <stephen@cass-ltd.co.uk>
Reply-To: stephen@cass-ltd.co.uk
Organization: Control and Software Solutions Ltd
To: pgsql-sql@postgresql.org
Subject: Select and functions
Date: Wed, 5 Nov 2003 14:26:05 +0000
User-Agent: KMail/1.5.4
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Content-Description: clearsigned data
Content-Disposition: inline
Message-Id: <200311051426.19315.stephen@cass-ltd.co.uk>

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

Hello all,

I am having a little bit of trouble here.=20

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

select firstname, lastname, replace(worktelephonenumber, ' ', '') AS workte=
l=20
from contacts;

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

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

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=3D
=3Dxe/b
-----END PGP SIGNATURE-----