Re: [SQL] plpgsql - Insert from a record variable?

2004-06-21 Thread basic
| '', ''; > first := false; >end if; why not use two arrays and append the name/values using array_append() and use array_to_string() to join them after that? -- basic ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] passing new/old record in pl/pgsql trigger functions to other functions

2004-05-30 Thread basic
e declare block but that didn't work at all (I get 'invalid column', which I assume it means rename did not work at all). Besides copying the record columns one by one, is there any other way to do this? -- basic ---(end of broadcast)---