| From: | roy_ <gprzezdz(at)elektron(dot)elka(dot)pw(dot)edu(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Field name |
| Date: | 2001-07-23 09:40:42 |
| Message-ID: | 9jgres$lc3$1@news.tpi.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
*/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Justin Clift | 2001-07-23 10:15:55 | Re: psql on red hat 7.1 |
| Previous Message | Stephen Robert Norris | 2001-07-23 08:59:55 | Re: Hangs with 7.1.2 and vacuum |