Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wWrac-002uIM-2Q for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Jun 2026 08:13:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wWrab-0067qk-2M for pgsql-hackers@arkaria.postgresql.org; Tue, 09 Jun 2026 08:13:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wWrab-0067qc-1B for pgsql-hackers@lists.postgresql.org; Tue, 09 Jun 2026 08:13:37 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wWraY-000000027OZ-2PAu for pgsql-hackers@postgresql.org; Tue, 09 Jun 2026 08:13:37 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=7818ZhYrW33o0np4nrtsQ9Dw45QcCJMq0UGviD7RD+Q=; b=BfGoeS5dTDIiU4aAKMNDQiMS1w 3tWHyQ7jcWWQmbtUmr3r1DiCUoQDIT7PKjPOk/s4vn85wIKTWS7iWHy08h4dqFJz+h5D3dZMnQ8m+ 8X6YtWP86tdPSZwB3ze4baJ/+S8+LfOxsEkXRduDkJBgKVlSmHlT/j200vFhzA2C0gzda7ZDaJ6sX sVozxmwz1t+KfKccZzqmv6psSArHBiMuJVailTugdtvZSpLanF+ZU+0YuNhUy7sqxKx3p0wmyJiY/ TJGvISrQ8fQ9wrz34LG6ApMwsH/b/ImL9XCVTRjt9n7IL40Bf+K+l9PZISiNOguupJjw+tf15i0Ff /GOo2P8w==; Received: from [2409:11:4120:300:b741:3b64:fa56:12a] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wWraQ-006EWV-04; Tue, 09 Jun 2026 08:13:28 +0000 Date: Tue, 09 Jun 2026 17:13:07 +0900 (JST) Message-Id: <20260609.171307.1883356507067957349.ishii@postgresql.org> To: assam258@gmail.com Cc: jian.universality@gmail.com, zsolt.parragi@percona.com, sjjang112233@gmail.com, vik@postgresfriends.org, er@xs4all.nl, jacob.champion@enterprisedb.com, david.g.johnston@gmail.com, peter@eisentraut.org, li.evan.chao@gmail.com, pgsql-hackers@postgresql.org Subject: Re: Row pattern recognition From: Tatsuo Ishii In-Reply-To: <20260604.132108.405136284364833955.ishii@postgresql.org> References: <20260604.132108.405136284364833955.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:b741:3b64:fa56:12a (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Henson, > Note, however, "PATTERN ()" is possible in R010 because it allows to > omit the DEFINE clause itself. My mistake. the DEFINE clause is mandatory in R010 too. Sorry for noise. Regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp