Re: [GENERAL] PL/pgsql - getting row from record

2004-11-16 Thread Matt
Thanks for the quick response! > Really, you'd be better off using one of the more interpreted languages > for this specific task though. Was afraid someone would say that. Time to polish up those tarnished perl skills ;) Matt ---(end of broadcast)-

Re: [GENERAL] PL/pgsql - getting row from record

2004-11-16 Thread Richard Huxton
Matt wrote: So, two questions: 1. Is there a better way of getting arbitrary columns from a record? Not really. 2. If not, will I run into problems with the name of the temporary table if two processes call this function at the same time, or are temp names unique to the particular session? Temporar

[GENERAL] PL/pgsql - getting row from record

2004-11-16 Thread Matt
Hi, I'm sure this has been asked before, but my searches haven't come up with an example. I'm writing a generic trigger function called from different tables in plpgsql that needs to get the value of the primary key column from OLD. I can find out the pkey column name by querying the system tabl