Postgres Pro
Downloads
Home   >   mailing lists

CREATE RULE.. RETURNING? - Mailing list pgsql-general

From Hannes Dorbath
Subject CREATE RULE.. RETURNING?
Date
Msg-id 46C56374.5010708@theendofthetunnel.de
Whole thread Raw
List pgsql-general
Tree view 
> In a rule for INSERT, UPDATE, or DELETE on a view, you can add a RETURNING clause that emits the view's columns. This
clausewill be used to compute the outputs if the rule is triggered by an INSERT RETURNING, UPDATE RETURNING, or DELETE
RETURNINGcommand respectively. 

Can someone enlighten me about the exact syntax to use this feature? I
just end up with syntax errors.

Thanks in advance.


--
Regards,
Hannes Dorbath

pgsql-general by date:

Previous
From: "Webb Sprague"
Date:
Subject: Re: [RESEND] Transaction auto-abort causes grief with Spring Framework
Next
From: "Mikko Partio"
Date:
Subject: Re: PostgreSQL clustering (shared disk)