Re: PL/PgSQL Question

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: Brian Knox <laotse(at)aol(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PL/PgSQL Question
Date: 2003-04-26 08:53:28
Message-ID: Pine.LNX.4.44.0304261421420.2770-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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?

If this is the case, why don't you try a triggered procedure? Follow the
below link to learn howto write triggered procedures:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=plpgsql-trigger.html

regards,
bhuvaneswaran

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Troy 2003-04-26 13:07:04 Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
Previous Message Andreas Pflug 2003-04-26 08:50:06 Re: Statement triggers 7.4 NEW/OLD