Re: plpgsql For SQLQuery Loop Flags Error

Поиск
Список
Период
Сортировка
От Rich Hall
Тема Re: plpgsql For SQLQuery Loop Flags Error
Дата
Msg-id 3FE1C451.5000708@micropat.com
обсуждение исходный текст
Ответ на plpgsql For SQLQuery Loop Flags Error  (Puneet Paul <paulptech@yahoo.com>)
Список pgsql-bugs
I should play with your code, but I'm lazy.
1)   lmfpLimit integer ALIAS for $3

is missing the trailing ";"
   lmfpLimit integer ALIAS for $3;

2) VARCHAR variables need a length
    curId varchar;
should be
    curId varchar(100);

3) I have not seen this style of declaration, where the argument type is repeated from the function's argument list.
Thismay be OK, but if nothing else helps maybe removing the type will help. 
     curTrackList char(15) ALIAS for $1;
    sliceFile    varchar  ALIAS for $2;
    lmfpLimit    integer  ALIAS for $3



>>
     curTrackList char(15) ALIAS for $1;
    sliceFile varchar     ALIAS for $2;
    lmfpLimit integer     ALIAS for $3
    mTrackDet RECORD;

    lpmfSum integer := 0;
    Sliced CONSTANT integer := 2;
    curId varchar;
    counter integer :=1 ;
>>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SELECT FOR UPDATE differs inside and outside a pl/pgsql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Urgent: Key constraints behaving weirdly