Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group