Re: SELECT INSTEAD

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. Any help would be
> much appreciated.

You have two queries here - which one is giving the problem?

> SELECT DISTINCT ON (m1.id)
...
> ;
> 
> SELECT d.id AS "ID",
...
> ;

--   Richard Huxton  Archonet Ltd