Re: I'm lost :-( with FOR...IN

On Tue, 7 Nov 2006, Alain Roger wrote:

> Hi,
>
> I' still with my stored procedure :
>
> -- Function: SP_U_001(typeofarticle varchar)
>
> -- DROP FUNCTION SP_U_001(typeofarticle varchar);
>
> CREATE OR REPLACE FUNCTION SP_U_001(IN typeofarticles VARCHAR)
>   RETURNS SETOF active_articles AS
> $BODY$
> DECLARE
>     myrec RECORD;
>     res active_articles;
> /**************************************/
> BEGIN
>   FOR myrec IN
>     select *
>     from articles, articletypes, department
>     where
>         articletypes.articletype_type = $1
>     AND articles.articletype_id = articletypes.articletype_id
>     AND articles.department_id = department.department_id
>     AND articles.validity_period_end > now()
>   LOOP
>     IF (myrec IS NOT NULL) THEN
>         res.article_type := myrec.articletypes.articletype_type;

I don't think the column names are going to keep their originating table
name inside the record, so the field probably needs
to be referred to as myrec.articletype_type not
myrec.articletypes.articletype_type.