Re: [GENERAL] cases in rules problem

2007-10-26 Thread Darnell Brawner
Ok i gave up just keeping this in rules so i did this CREATE OR REPLACE RULE version AS ON UPDATE TO vmain DO INSTEAD select version2 (OLD.id,NEW.title,OLD.parent_id,NEW.public,OLD.public); CREATE OR REPLACE FUNCTION version2(int,varchar,int,bool,bool) RETURNS VOID LANGUAGE 'plpgsql' AS '

Re: [GENERAL] cases in rules problem

2007-10-26 Thread Erik Jones
On Oct 26, 2007, at 10:28 AM, Darnell Brawner wrote: I am trying to make a sql based versioning system. I am working on a Ruby on Rails project and am using a plugin called hobo the plugin can do some nice things but over all its lame but thats what i got to work with. The problem is hobo d

[GENERAL] cases in rules problem

2007-10-26 Thread Darnell Brawner
I am trying to make a sql based versioning system. I am working on a Ruby on Rails project and am using a plugin called hobo the plugin can do some nice things but over all its lame but thats what i got to work with. The problem is hobo does a lot of work for you but the database most be in