Hello Richard, Richard Huxton a écrit : >>>> ERREUR: wrong record type supplied in RETURN NEXT >>>> CONTEXTE : PL/pgSQL function "hds_bw_find_sn_live" line 26 at return next >>>> >>>> Does someone maybe knows what it could be ? >>>> >>>> This is (a part of) my function : >>>> >>>>> CREATE OR REPLACE FUNCTION rma.find_sn_live (varchar(30)) RETURNS SETOF >>>>> rma.serial_number >>> This is a different function. Function "hds_bw_find_sn_live" has the >>> wrong type for its "return next". >> Hello, >> >> Thanks a lot for your reply : the difference in name is just a mistake >> in my email but in fact it is the same function, I just renamed it wrong >> when doing the "cleaning" before posting my email... > > In that case - have you changed the definition of table > rma.serial_number since you defined the function?
No, I just do the test just after the "CREATE OR REPLACE FUNCTION". I saw somwhere it could be the order of the fields ? Denis -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql