Re: Row pattern recognition

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: Row pattern recognition
Дата
Msg-id a13e5b7d-c131-44b3-9d2a-2c57d22a8251@postgresfriends.org
обсуждение исходный текст
Ответ на Re: Row pattern recognition  (Tatsuo Ishii <ishii@postgresql.org>)
Ответы Re: Row pattern recognition
Список pgsql-hackers


On 22/10/2024 12:19, Tatsuo Ishii wrote:
Acording to ISO/IEC 9075-2:2016 "4.21.2 Row pattern navigation operations",
  <row pattern navigation operation> evaluates a <value expression> VE  in a row NR, which may be different than current row CR.

From this I think PREV(col + 1) should be interpreted as:

1. go to the previous row.
2. evaluate "col + 1" at the current row (that was previous row).
3. return the result.

If my understanding is correct, prev(price + 1) has the same meaning
as prev(price) + 1.



This is how I read the specification also.

--

Vik Fearing

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