Search Postgresql Archives

Re: SQL Rule

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bert wrote:

This rule is creating first of all the insert and then i can run an
Update on this insert, so far its functioning. Your definition is quite
good but what are doing when you change the table definition? Rewrite
all Rules?
I actually use a data dictionary processor that automatically generates the trigger code and also modifies table structures. Your example would look like this:

table example {
  column { col_A; col_B; }
  column col_C {
    chain calc {
        test { return: @col_A + @col_B; }
 }
}

This tool, called "Andromeda" is available for download if you like, but we consider the current version "pre-Alpha". The entire feature set is defined and I use it for all of my projects, but we are still stabilizing and documenting. If you are interested in being a very early adopter, drop me a line off-list.
begin:vcard
fn:Kenneth  Downs
n:Downs;Kenneth 
email;internet:ken@xxxxxxxxxx
tel;work:631-689-7200
tel;fax:631-689-0527
tel;cell:631-379-0010
x-mozilla-html:FALSE
version:2.1
end:vcard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux