Re: [SQL] Simple plpgsql question

2006-04-14 Thread Volkan YAZICI
On Apr 13 11:38, Todd Kennedy wrote: > What I'd also like to do is have it create a new row in a different > table using the automatically assigned id as a reference, but I'm > unsure of how to obtain the id of the newly created row in the first > table. If I understand you right, you're refering

Re: [SQL] Simple plpgsql question

2006-04-14 Thread Terry Lee Tucker
On Thursday 13 April 2006 11:38 pm, "Todd Kennedy" <[EMAIL PROTECTED]> thus communicated: --> Hi, --> --> I have, what I hope to be, a simple question about plpgsql. --> --> I have a trigger on a table right now that updates a count everytime --> that a new record is entered into a database (or re

[SQL] Simple plpgsql question

2006-04-13 Thread Todd Kennedy
Hi, I have, what I hope to be, a simple question about plpgsql. I have a trigger on a table right now that updates a count everytime that a new record is entered into a database (or removed). What I'd also like to do is have it create a new row in a different table using the automatically assign