Re: [GENERAL] Function Question - Inserting into a table with foreign constraints

2011-11-05 Thread Raymond O'Donnell
On 05/11/2011 14:46, Brandon Phelps wrote: > > With the method you outlined will I notice any huge performance > impacts? The application would be parsing incoming data from another > 3rd party application and could, at times, be executing the function in > very fast succession, although never tw

Re: [GENERAL] Function Question - Inserting into a table with foreign constraints

2011-11-05 Thread David Johnston
On Nov 5, 2011, at 10:46, Brandon Phelps wrote: > On 11/5/2011 10:35 AM, Raymond O'Donnell wrote: >> On 05/11/2011 04:34, Brandon Phelps wrote > > With the method you outlined will I notice any huge performance impacts? The > application would be parsing incoming data from another 3rd party ap

Re: [GENERAL] Function Question - Inserting into a table with foreign constraints

2011-11-05 Thread Brandon Phelps
On 11/5/2011 10:35 AM, Raymond O'Donnell wrote: On 05/11/2011 04:34, Brandon Phelps wrote: Hello all, Could someone give me an example as to how I would accomplish something like this with a function?: 3 tables: tableA: id (serial), name (varchar), description (varchar), subcat_id (integer) t

Re: [GENERAL] Function Question - Inserting into a table with foreign constraints

2011-11-05 Thread Raymond O'Donnell
On 05/11/2011 04:34, Brandon Phelps wrote: > Hello all, > > Could someone give me an example as to how I would accomplish something > like this with a function?: > > 3 tables: > > tableA: id (serial), name (varchar), description (varchar), subcat_id > (integer) > tableB: id (serial), subcat_name