Re: Row pattern recognition
От | Erik Rijkers |
---|---|
Тема | Re: Row pattern recognition |
Дата | |
Msg-id | f1b24ec2-9b36-90f3-8c58-83c70991f9d8@xs4all.nl обсуждение исходный текст |
Ответ на | Re: Row pattern recognition (Tatsuo Ishii <ishii@sraoss.co.jp>) |
Ответы |
Re: Row pattern recognition
Re: Row pattern recognition |
Список | pgsql-hackers |
Op 9/22/23 om 07:16 schreef Tatsuo Ishii: >> Attached is the fix against v6 patch. I will include this in upcoming v7 patch. > > Attached is the v7 patch. It includes the fix mentioned above. Also (Champion's address bounced; removed) Hi, In my hands, make check fails on the rpr test; see attached .diff file. In these two statements: -- using NEXT -- using AFTER MATCH SKIP TO NEXT ROW result of first_value(price) and next_value(price) are empty. Erik Rijkers > this time the pattern matching engine is enhanced: previously it > recursed to row direction, which means if the number of rows in a > frame is large, it could exceed the limit of stack depth. The new > version recurses over matched pattern variables in a row, which is at > most 26 which should be small enough. > > Best reagards, > -- > Tatsuo Ishii > SRA OSS LLC > English: http://www.sraoss.co.jp/index_en/ > Japanese:http://www.sraoss.co.jp
В списке pgsql-hackers по дате отправления: