Re: plpgsql triggers in rules

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: chester c young <chestercyoung(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: plpgsql triggers in rules
Date: 2006-01-12 17:01:41
Message-ID: 43C68B75.3040806@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, Chester,

chester c young wrote:
> is is possible for to have a "do instead" trigger on a view that is a
> plpgsql function?

Kinda.

They're called "rules", not "triggers". See
http://www.postgresql.org/docs/8.1/interactive/rules.html

HTH,
Schabi
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Schaber 2006-01-12 17:04:47 Re: exceptions in rules
Previous Message Tom Lane 2006-01-12 16:05:49 Re: error code invalid_input_syntax