Re: Ideas, suggestions to rules (based on a real problem)

From: Georg Steffers <georg(at)steffers(dot)org>
To: Georg Steffers <georg(at)steffers(dot)org>
Cc: PostgreSQL-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Ideas, suggestions to rules (based on a real problem)
Date: 2003-03-29 10:56:46
Message-ID: 1048935406.2559.51.camel@georg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry, a small mistake is in the first example

Am Sam, 2003-03-29 um 11.39 schrieb Georg Steffers:
> CREATE RULE jokus AS ON UPDATE
> TO tab1 WHERE bit_length(OLD.f1)<bit_length(NEW.f1)
> DO ONCE
> UPDATE jokus SET f1=bit_set_len(f1,bit_length(NEW.f1));

must be

CREATE RULE jokus AS ON UPDATE
TO tab1 WHERE bit_length(OLD.f1)<bit_length(NEW.f1)
DO ONCE
UPDATE tab1 SET f1=bit_set_len(f1,bit_length(NEW.f1));

Best regards
Georg Steffers

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-03-29 11:25:07 Re: System dump, but not in the default format
Previous Message Georg Steffers 2003-03-29 10:39:56 Ideas, suggestions to rules (based on a real problem)