On Thursday 23 November 2006 08:45 pm, Tom Lane wrote: > Mulham freshcode <[EMAIL PROTECTED]> writes: > > execute sql_str1 into svc_data_rec ; > > > > svc_data_rec is a RECORD, which is supposed to be dynamic. > > This should work --- in PG 8.1 or later. In older versions you'd have > to fool around with a FOR ... IN EXECUTE ... loop. > > regards, tom lane The documentation for pl/pgsql in 8.1 and higher says different.
http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN " SELECT INTO is not currently supported within EXECUTE." The change is reflected in the HISTORY text though. How is the best way to get a change made to the documentation? -- Adrian Klaver [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
