Re: [SQL] Assistance with a trigger

2007-07-25 Thread Paul Lambert
chester c young wrote: http://www.postgresql.org/docs/8.2/interactive/plpgsql.html I found the doc to be quite good. I'd start there, and then, if you have problems, email again. I'd read that before... but another re-read triggered a thought pattern and I've got it working now - it's also

Re: [SQL] Assistance with a trigger

2007-07-25 Thread chester c young
--- Paul Lambert <[EMAIL PROTECTED]> wrote: > I have some triggers in an MS SQL server database which I need to > copy > across to a PG database. I've not yet done triggers in PG so I was > hoping to get a little bit of a pointer on the first one as a place > to > start and work my way through

[SQL] Assistance with a trigger

2007-07-25 Thread Paul Lambert
I have some triggers in an MS SQL server database which I need to copy across to a PG database. I've not yet done triggers in PG so I was hoping to get a little bit of a pointer on the first one as a place to start and work my way through from there. The trigger looks like thus: CREATE TRIGGE