trigger or rule?

From: "Ricky" <ricky(at)babonmultimedia(dot)com>
To: "postgre" <pgsql-odbc(at)postgresql(dot)org>
Subject: trigger or rule?
Date: 2004-01-06 10:54:12
Message-ID: 011801c3d462$c3019450$0200a8c0@bandeng
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

hello,

i want to ask a simple question.

i tried to make validation in postgre when data = NULL then data will be
changed into 0
so what should i do? using rule or trigger ?

i already tried using rule :
CREATE RULE synsellingprice_kosongtozero AS ON UPDATE TO synsellingprice DO
UPDATE synsellingprice SET sellingprice = 0 WHERE (synsellingprice.productid
= new.productid); when i tried to update, then error said 1"ERROR: query
rewritten 100 times, may contain cycles"

pls give me advices

Thanks you very much
Ricky

Browse pgsql-odbc by date

  From Date Subject
Next Message Guy Steven 2004-01-08 00:31:44 No Current Record
Previous Message Hiroshi Inoue 2004-01-05 09:36:21 Re: Bug correction