Select and functions

From: "Stephen J(dot) Thompson" <stephen(at)cass-ltd(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Select and functions
Date: 2003-11-05 14:26:05
Message-ID: 200311051426.19315.stephen@cass-ltd.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message terry 2003-11-05 14:38:11 Re: Select and functions
Previous Message Patrick JACQUOT (DSI NOISIEL) 2003-11-05 09:34:24 Re: Please help me to slove this SQL statements