Re: Row pattern recognition - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: Row pattern recognition
Date
Msg-id 20260926.205323.567735777208602850.ishii@postgresql.org
Whole thread
In response to Re: Row pattern recognition  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: Row pattern recognition
List pgsql-hackers
Currently the keyword RUNNING with row pattern navigation in the
DEFINE clause is not supported.  (As FINAL can only be used in
MEASURES clause and we do not support MEASURES, we do not need to
worry about FINAL for now.)

So question is whether we should support RUNNING keyword.

Even if RUNNING keyword support is lacking, current patch effectively
supports RUNNING semantics with row pattern navigation (according to
the standard, the default is RUNNING). So supporting RUNNING keyword
gives users only minor benefit, for example in migration from other
DBMSs that use the RUNNING keyword in the target system.  In my
opinion, the effort to add support for the RUNNING keyword is not
worth the trouble. Thoughts?

Regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp



pgsql-hackers by date:

Previous
From: Enrique Sánchez
Date:
Subject: Re: Extended statistics improvement: multi-column MCV missing values
Next
From: Etsuro Fujita
Date:
Subject: Re: Several issues with postgres_fdw stats import