SELECT INSTEAD - Mailing list pgsql-sql

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

SELECT DISTINCT ON (m1.id)

                        UPPER(m1.id) AS id,

                        UPPER(m1.first_name) AS first_name,

                        UPPER(m1.last_name) AS last_name,

                        UPPER(m1.company) AS company,

                        UPPER(m1.address1) AS address1,

                        UPPER(m1.address2) AS address2,

                        UPPER(m1.suburb) AS suburb,

                        UPPER(m1.state) AS state

INTO TEMP TABLE mail_duplicates

FROM    maillist as m1

INNER JOIN maillist as m2 ON

                        (           m1.id <> m2.id

                        AND      UPPER(m1.first_name) = UPPER(m2.first_name)

                        AND      UPPER(m1.last_name) = UPPER(m2.last_name)

                        AND      UPPER(m1.suburb) = UPPER(m2.suburb)

                        )

WHERE  TRIM(m1.first_name) <> ''

 AND     TRIM(m1.last_name) <> ''

;

SELECT d.id AS "ID",

                        INITCAP(d.first_name) AS first_name,

                        INITCAP(d.last_name) AS last_name,

                        INITCAP(d.company) AS company,

                        INITCAP(d.address1) AS address1,

                        INITCAP(d.address2) AS address2,

                        d.suburb AS suburb,

                        d.state AS state

FROM    mail_duplicates AS d

ORDER BY d.last_name, d.first_name, d.suburb, d.id

;