PL/PgSQL Question - Mailing list pgsql-sql

From Brian Knox
Subject PL/PgSQL Question
Date
Msg-id Pine.LNX.4.53.0304251125230.19187@tao.office.aol.com
Whole thread Raw
Responses Re: PL/PgSQL Question  ("A.Bhuvaneswaran" <bhuvansql@myrealbox.com>)
List pgsql-sql
From within a postgresql rule, is it possible to get at the values
specified in the WHERE clause of the query?

For example, given the query:

DELETE FROM map_tr_relationship WHERE fk_tr1_id = 4 AND fk_tr2_id = 5 AND
fk_tr_relationship_type_id = 1 AND from_tr_request_id = 4;

I want to intercept that query with a rule, and with DO INSTEAD call a
stored procedure and pass the values in the where clause to that stored
proc? Is this possible? If so, how?

Thanks for any info.

Brian Knox
laotse@aol.net



pgsql-sql by date:

Previous
From: pginfo
Date:
Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
Next
From: Rajesh Kumar Mallah
Date:
Subject: /* */ comments showing up in pg_stat_activity