Обсуждение: continue in plpgsql 7.4

Поиск
Список
Период
Сортировка

continue in plpgsql 7.4

От
"Gauthier, Dave"
Дата:

How does one effectively doa “continue” in plpgsql v7.4?

 

I believe “continue” is supported in v8, but not 7.   At any rate, “continue” gets flagged as a syntax error in the code I’m trying.

 

Lacking “continue”, what would you suggest? 

 

Thanks

-dave

 

 

Re: continue in plpgsql 7.4

От
Tom Lane
Дата:
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> Lacking "continue", what would you suggest?

EXIT out of a labeled BEGIN block immediately within the loop.

On the whole, though, if you're doing development for PG 7.4 my
reaction is "why"?  Your effort would be better invested in an update.

            regards, tom lane