Re: Ideas, suggestions to rules (based on a real problem) - Mailing list 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