Re: error on last line of function

On Saturday 23 Nov 2002 3:38 am, Matthew Nuzum wrote:
> NOTICE:  plpgsql: ERROR during compile of delete_page near line 81
> ERROR:  parse error at or near ";"
>
> Line 81 is the last line of the function and merely says: END;

Ah, plpgsql's error reporting. Not always the most useful guide, though I
don't think it's easily changed.

> DECLARE
>   temp record;
> BEGIN
>   IF old.page_type = ''f''
>   THEN
>      IF old.ftr_type = ''adf''
>      THEN
>          -- adf features store id in ftr_data
>          SELECT INTO temp delete_adf(old.ftr_data);
>      ELSE IF old.ftr_type = ''cal''
>      THEN
>          -- cal features do not store id in ftr_data
>          -- get the id
>          SELECT  INTO temp * FROM ftr_cal_calendar
>          WHERE accountid = old.accountid AND name = substr(old.path,2);
>          SELECT INTO temp delete_cal(temp.calendarid);
>      ELSE IF old.ftr_type = ''cyu''
>      THEN
>          -- cyu stores id in ftr_data
>          SELECT INTO temp delete_cyu(old.ftr_data);
>      ELSE IF old.ftr_type = ''fa2'' OR old.ftr_type = ''faq''

I think the problem is you're missing the "END IF" from all the intermediate
IFs. I don't think there actually is an "ELSEIF" structure, it's just an ELSE
followed by an IF, so the IF needs to be concluded as normal. From the
manual:

IF demo_row.sex = ''m'' THEN
  pretty_sex := ''man'';
ELSE
  IF demo_row.sex = ''f'' THEN
    pretty_sex := ''woman'';
  END IF;
END IF;

See if that helps you any. Of course there may be a typo somewhere else too.
I'd suggest reducing the function to a single IF and expanding one block at a
time to spot the problem.

--
  Richard Huxton