subject:"\[SQL\] Trouble with CREATE FUNCTION"

Re: [SQL] Trouble with CREATE FUNCTION

2001-02-22 Thread Jie Liang

1.The following command tells the database where to find the shared object for the PL/pgSQL language's call handler function. CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C'; 2.The command CREATE TRUS

[SQL] Trouble with CREATE FUNCTION

2001-02-22 Thread S Bey

Dear All, I have tried creating a function as follows: CREATE FUNCTION chkTelephone () RETURNS OPAQUE AS ' BEGIN IF EXISTS (SELECT * FROM tenant t WHERE t.areacode = NEW.areacode AND t.telephone = NEW.telphone) THEN RAISE