Обсуждение: Field name

Welcome.

Here is the problem (one of my friends)


create function remove_picture()
RETURNS OPAQUE AS '
 DECLARE
  field_name TEXT;
 BEGIN
  field_name := TG_ARGV[0];
  DELETE FROM picture WHERE picture_id=OLD.field_name;
  RETURN OLD;
 END;
'


He needs create universal function for many tables to remowe record
(dont want to use references (FK))
create sql statment
  DELETE FROM picture WHERE picture_id=OLD.field_name;

field_name is field name not the same name for this tables.
  DELETE FROM picture WHERE picture_id=OLD.'field_name';


Sorry for my english

Best Regareds


--
/*
Kto nie pyta ten błądzi.
Kto pyta ten błądzi z innymi
*/