From: Richard Huxton <dev@archonet.com>
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT INSTEAD
Date: Thu, 29 Mar 2007 07:49:31 +0100
Message-ID: <460B617B.4010005@archonet.com> (raw)
In-Reply-To: <00ab01c771c4$1ec9aa50$9b0014ac@wbaus090>
References: <00ab01c771c4$1ec9aa50$9b0014ac@wbaus090>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, phillip.smith@weatherbeeta.com.au
Subject: Re: SELECT INSTEAD
In-Reply-To: <460B617B.4010005@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox