Re: [SQL] Rules, functions and RETURNING

2009-09-18 Thread Nico Mandery
Adrian Klaver wrote: > On Thursday 17 September 2009 8:35:52 am Nico Mandery wrote: >> Hello list, >> >> I am trying to wirte a rule which calls a PLPgSQL-function upon an >> Insert in a table. Here is a somewhat simplified example of what i got >> so far: >> >> CREATE TABLE mytable ( >> mytab

Re: [SQL] Rules, functions and RETURNING

2009-09-17 Thread Adrian Klaver
On Thursday 17 September 2009 8:35:52 am Nico Mandery wrote: > Hello list, > > I am trying to wirte a rule which calls a PLPgSQL-function upon an > Insert in a table. Here is a somewhat simplified example of what i got > so far: > > CREATE TABLE mytable ( > mytable_id serial PRIMARY KEY, >

[SQL] Rules, functions and RETURNING

2009-09-17 Thread Nico Mandery
Hello list, I am trying to wirte a rule which calls a PLPgSQL-function upon an Insert in a table. Here is a somewhat simplified example of what i got so far: CREATE TABLE mytable ( mytable_id serial PRIMARY KEY, something text ); CREATE OR REPLACE FUNCTION _rule_insert_my(someth