Is it possible to avoid a rule calling itself, as it were?
i.e.
CREATE TABLE test (testnumber float8,testid serial primary key);
CREATE FUNCTION adjust(float8) RETURNS '
SELECT dpow(1.14,$1) AS result;'
LANGUAGE 'SQL';
CREATE RULE testtest AS ON INSERT TO test
DO INSTEAD INSERT INTO test (testnumber) VALUES
(adjust(new.testnumber));
INSERT INTO test VALUES (2);
now gets into an endless loop, which postgres intelligently breaks out
of with an ERROR:
What I want is just to make that substitution once!
If possible I want to do this without rewriting my application to use
a view of the table rather than the table itself...
Yours,
Moray
----------------------------------------------------------------------
----------------
Moray.McConnachie@computing-services.oxford.ac.uk
----- Original Message -----
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: PostgreSQL-announce <announce@postgreSQL.org>; PostgreSQL-general
<pgsql-general@postgreSQL.org>
Sent: Thursday, November 18, 1999 12:41 PM
Subject: [GENERAL] Book completed through chapter 6
> I have completed through chapter 6 of my book, "PostgreSQL:
> Introduction and Concepts." Of course, this is only the first
draft.
> It can be viewed at:
>
> http://www.postgresql.org/docs/awbook.html
>
> There are major improvements in this version. I have added sections
to
> chapter 4 dealing with DEFAULT and functions/operators. The figure
> placement and font usage is improved.
>
> Chapter 6 covers using multiple tables and joins. This was a very
> difficult chapter for me to write.
>
> --
> Bruce Momjian | http://www.op.net/~candle
> maillist@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania
19026
>
> ************
>
>