Quick Links

Re: Deprecating RULES

From:	Greg Stark <stark(at)mit(dot)edu>
To:	Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:	Peter Geoghegan <peter(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Deprecating RULES
Date:	2012-10-15 10:41:54
Message-ID:	CAM-w4HNVrkg3yJ3dkWDPxiDMqH2bO_gcN49RpVORSwgBSS1u1g@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

On Mon, Oct 15, 2012 at 8:00 AM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> Please can anyone show me the SQL for a rule that cannot be written as
> a view or a trigger? I do not believe such a thing exists and I will
> provide free beer to the first person that can prove me wrong.

Being written as a view doesn't help you because views use rules. I
repeat, the very fact that we need rules to implement views prove
rules are necessary for some purposes.

--
greg

In response to

Re: Deprecating RULES at 2012-10-15 07:00:57 from Simon Riggs

Responses

Re: Deprecating RULES at 2012-10-15 11:37:37 from Peter Geoghegan
Re: Deprecating RULES at 2012-10-15 13:07:21 from Simon Riggs
Re: Deprecating RULES at 2012-10-15 15:54:27 from Hannu Krosing

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Pavel Stehule	2012-10-15 10:48:53	Re: proposal - assign result of query to psql variable
Previous Message	Shigeru HANADA	2012-10-15 10:17:42	Re: proposal - assign result of query to psql variable