Re: for statement, adding a STEP clause?

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: for statement, adding a STEP clause?
Дата
Msg-id 4453034B.7000003@dunslane.net
обсуждение исходный текст
Ответ на Re: for statement, adding a STEP clause?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:

>"Jaime Casanova" <systemguards@gmail.com> writes:
>  
>
>>there is a chance to add a STEP clause to the FOR statement in plpgsql?
>>    
>>
>
>This is not free: it'd require making STEP a reserved word (at least
>within plpgsql) which is contrary to spec.  I think you need to make
>a pretty good case why the value of the feature outweighs breaking
>applications that have perfectly-legally used "step" as an identifier.
>  
>

This isn't available in PL/SQL, is it? That doesn't mean we shouldn't do it, of course, but it might lessen any
perceivedimperative.
 

Maybe using BY instad of STEP as the keyword would make it easier, since its occurrence in SQL makes it less likely to
beused as a variable.
 

cheers

andrew



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: for statement, adding a STEP clause?
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Exports from postgres