Phillip Smith wrote:
I'm trying to create a view of the query below, but I'm being barked at
about "rules on SELECT must have action INSTEAD SELECT". I don't have any
rules in my database, and I don't know how this query is trying to create
one. The query does work if I just run it interactively
o:[EMAIL PROTECTED]
Sent: Thursday, 29 March 2007 16:49
To: Phillip Smith
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] SELECT INSTEAD
On Thu, Mar 29, 2007 at 03:35:52PM +1000, Phillip Smith wrote:
> I'm trying to create a view of the query below, but I'm being barked at
> about
On Thu, Mar 29, 2007 at 03:35:52PM +1000, Phillip Smith wrote:
> I'm trying to create a view of the query below, but I'm being barked at
> about "rules on SELECT must have action INSTEAD SELECT". I don't have any
> rules in my database, and I don't know how this query is trying to create
> one.
ht
Hi all,
I'm trying to create a view of the query below, but I'm being barked at
about "rules on SELECT must have action INSTEAD SELECT". I don't have any
rules in my database, and I don't know how this query is trying to create
one. The query does work if I just run it interactively. Any help w
Hi, Tom,
On Thu, 28 Oct 2004 10:22:47 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> > Is it possible to create a ON SELECT DO INSTEAD rule on a table?
>
> Not unless you want it to become a view.
That's what I suspected, after scanning the docs.
Thanks,
Markus
--
markus schaber | dipl. informa
Markus Schaber <[EMAIL PROTECTED]> writes:
> Is it possible to create a ON SELECT DO INSTEAD rule on a table?
Not unless you want it to become a view.
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all lis
Hello,
[I hope this is no FAQ, but I did neither find anything about it in the
PostgreSQL FAQ, nor get any hit on RULE or INSTEAD on the mailing list
archive search¹...]
Is it possible to create a ON SELECT DO INSTEAD rule on a table?
All of my tries to do so failed by either complaining that th