Re: Problem with return type of function ???

Hello Richard,

Richard Huxton a écrit :
>> I saw somwhere it could be the order of the fields ?
> 
> Not if you are doing "SELECT * FROM".
> 
> Create an empty test database and a short script to create the table and
> function, insert a couple of rows then call the function. If you wrap
> the whole thing in BEGIN ... ROLLBACK we can change things until we see
> the problem.
> 
> The other thing you could try is printing out row before returning it:
>   RAISE NOTICE 'row = %', row;
>   RETURN NEXT ROW;
> It might be you've not got what you were expecting.

Thanks a lot, good idea...

But it looks good :

> SELECT * FROM rma.test ('19G256259');
> NOTICE:  row = (12066602,19G256259,170224,PN6405B,2009-09-22,"FORERUNNER 405 NOIR",2009-09-22,15090,14748)
> ERREUR:  wrong record type supplied in RETURN NEXT
> CONTEXTE : PL/pgSQL function "test" line 12 at return next
> 
> \d rma.serial_number
>                                        Table « rma.serial_number »
>    Colonne   |         Type          |                           Modificateurs
> -------------+-----------------------+-------------------------------------------------------------------
>  sn_id       | bigint                | not null default nextval('rma.serial_number_sn_id_seq'::regclass)
>  sn          | character varying(30) |
>  no_client   | integer               |
>  no_art_bw   | character varying(11) |
>  sn_fc_date  | date                  |
>  desc_fr     | character varying(40) |
>  sn_cm_date  | date                  |
>  no_facture  | integer               |
>  no_commande | integer               |

Denis