I know this is off topic, but I know many of you use PostgreSQL so I thought I would start here. I am writing a query in a function that does not work and was wondering if anyone sees a problem. My table follows:
Table 1 ---------- id_user rel_id_section idx_registration And the Function is: CREATE OR REPLACE FUNCTION unregister_user() RETURNS OPAQUE AS ' DECLARE current_registration int2; maximum_registration int2; BEGIN SELECT INTO registration_record * FROM registration WHERE rel_id_section = OLD.rel_id_section AND id_user = OLD.id_user; IF FOUND THEN RAISE EXCEPTION ''user is enrolled''; ELSE RAISE EXCEPTION ''No registration exists: %, %'', OLD.id_user, OLD.rel_id_section; END IF; RETURN NULL; END ' LANGUAGE 'plpgsql'; I have put a delete trigger that runs this function and it does not matter if the record exists or not it always returns that "No registration exists." If I remove the portion of the where clause that verifies the user the query works fine. I belive I need to quote the data or something, but can not find in the docs how. Does anyone have any ideas? Thanks, Chad -- Pop3Now Personal, Manage 5 Email Accounts From 1 Secure Window Sign Up Today! Visit http://www.pop3now.com/personal _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list