CREATE RULE.. RETURNING?

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: CREATE RULE.. RETURNING?
Date: 2007-08-17 08:59:32
Message-ID: 46C56374.5010708@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> In a rule for INSERT, UPDATE, or DELETE on a view, you can add a RETURNING clause that emits the view's columns. This clause will be used to compute the outputs if the rule is triggered by an INSERT RETURNING, UPDATE RETURNING, or DELETE RETURNING command 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

Browse pgsql-general by date

  From Date Subject
Next Message Mikko Partio 2007-08-17 09:12:16 Re: PostgreSQL clustering (shared disk)
Previous Message Webb Sprague 2007-08-17 08:46:19 Re: [RESEND] Transaction auto-abort causes grief with Spring Framework