Hi all.
Under PGSQL v8.2.4, in a PL/PgSQL function whenver I try to run this
statement:
INSERT INTO table1 SELECT var1.*;
I get his message:
ERROR: record type has not been registered
CONTEXT: SQL statement "INSERT INTO table1 select $1 .*"
Of course var1 has been declared as table1 type.
I suspect this could be a bug. But cannot be sure.
Any hint?
--
Vincenzo Romano -= NotOrAnd.IT Information Technologies =-
tel +39 0823 454163 | cel +39 339 8083886 | fax +39 02 700506964
<Smooth seas never make experienced sailormen>
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
