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.94.2) (envelope-from ) id 1vAgTv-00506O-Pg for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Oct 2025 03:22:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAgTu-00Duf8-IJ for pgsql-hackers@arkaria.postgresql.org; Mon, 20 Oct 2025 03:22:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAgTu-00DudP-84 for pgsql-hackers@lists.postgresql.org; Mon, 20 Oct 2025 03:22:45 +0000 Received: from mail-pg1-x534.google.com ([2607:f8b0:4864:20::534]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vAgTq-002iIv-2p for pgsql-hackers@lists.postgresql.org; Mon, 20 Oct 2025 03:22:44 +0000 Received: by mail-pg1-x534.google.com with SMTP id 41be03b00d2f7-b679450ecb6so2851181a12.2 for ; Sun, 19 Oct 2025 20:22:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760930562; x=1761535362; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=k8GV4+C7YxBwVaH7yfgBP0B2RFIdjuuiElUqkf2ZmPU=; b=Eh/h0JqstjMUD08JSCLATTguOnqHNBmJf0XkCwJ5rKwd1YjyS1odfOhQwfHjdDI5ph HEgjjbow+czfSXAjul0BUsII0SjVnb5ypNE/jDOJwVWiZ8Ij64D0o83dOI9XiY7OoHcd /FApN02rvD3ThqU09rzRV8VxdPzE1700oldcl6uP3CKwShPVGfqKP2ZNAWUo4HIACYhT DlWSd6HEcMbLQCJKLeYn7P3CdGgOF053Zfa2N17I7xlyrY4gyO8CHxWrEo0F4a6IKZLw l97nuMtaoYYigY/52u7p1XfLGhgzQOJQDkzBmhKoj822V3U1p8qNsUJ5aw3Rta29qXLn FGrg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760930562; x=1761535362; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=k8GV4+C7YxBwVaH7yfgBP0B2RFIdjuuiElUqkf2ZmPU=; b=T2Wpu5a5Ux/E80v5ZXRrWyJ6OdsEq+YNxzTlm8yeD2/P7VAn7Gse6IKlq0DKXc+L03 +N3/n0560KGKgW/jcn4i8DTCdZLtkhr0KcPlmxMp+Qnh6V1ADYNA+nTFY/qyDcK58YLJ J8oRAn9SvSuLNcfGLWox/c1yWiTS0aTdFE2Qzh9aU+OE10+JwhSio4LEBlNkBgEcIGXo fz3s3FJ2oE56YEssdY0Jls+/gg7vGU7mkqYBYiaMHuSLdjmJS9gj3IgotBOynLvibTzQ DLYZssy8YU8V7cvA87O+6LUv3udvQmHeLo4tn6TO+gGJIHNYUddvf+PekEhqSTf3DCkC 660g== X-Forwarded-Encrypted: i=1; AJvYcCVvkqQjf2zfoOoFsPdOZ8MG6x0VelqzNgOSMaP2XBOCuea1p42W4/RA4VOx5Dc/rPBsvi1fRxo4aIGbowNy@lists.postgresql.org X-Gm-Message-State: AOJu0Yzb2bYR/ePn/xIQmSTk+dijwrUtoxOY6M4Hw09NW1bpIqKqzrl/ LqRtagcl2WE87kzgq7XipIx2nva9VCg89WitU/oKezo9lO/kT1NbTN4l X-Gm-Gg: ASbGnctpcroeMYKJCS3BlSN26rEjfIMf6RDsLUoTbIXto6vGJR5TUMBsZA05s9lcE3e 96EMFMt5B3ADfT6q2BAooVrIGOZDZBZsZ9ELtJfw+lERTWIXrZslchgQXGRjKdvjqkf3YnzpNLd iGh0F/Ot/8GlROBaSXFHAISZwL5WrUBIVbCVoetrqW1DB1VkFmk0t3qQRoNm+NI2R6NFRm/e8ym 5jpkz0kMeSCFsFeR2mkNQFPDR/Jr8lbDMtQLr99JyUsj4JR0P3b5XwuQk8WF4IDweDIS7mf/rZT XBiO1gatHCKQ2GkhYWt2p/h13QrB4U/UYmE+mRxOP9Ok5tL1k2FjA3fEINaTTjvaMJbSvQY+DmG BaVIyfm503KwdO4MZpos03HSlFzGOkwK8iN131iEwHa7TyjbRg3r2zAHJtSdpKCycYBe14HYR2a ciXVaHDD040ZXWkYITuM8pYw== X-Google-Smtp-Source: AGHT+IHn/i0gCWLSbkvp98yfx+D7FVI8ik5psmbiwDAW0sW8uFAMiUyTehmOh2a3KvmA4wjRD/odXg== X-Received: by 2002:a17:902:eccb:b0:290:c0d7:237d with SMTP id d9443c01a7336-290caf84635mr173903795ad.36.1760930561687; Sun, 19 Oct 2025 20:22:41 -0700 (PDT) Received: from smtpclient.apple ([170.178.170.211]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-2924700a883sm67067125ad.49.2025.10.19.20.22.38 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 19 Oct 2025 20:22:41 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\)) Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options From: Chao Li In-Reply-To: <20251019.185323.1616138750375579950.ishii@postgresql.org> Date: Mon, 20 Oct 2025 11:22:04 +0800 Cc: tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org, pramsey@cleverelephant.ca, ojford@gmail.com, peter@eisentraut.org, krasiyan@gmail.com, vik@postgresfriends.org, andrew@tao11.riddles.org.uk, david@fetter.org Content-Transfer-Encoding: quoted-printable Message-Id: References: <2952409.1760023154@sss.pgh.pa.us> <20251011.090731.1451293026979559494.ishii@postgresql.org> <20251013.134332.1917267590891336373.ishii@postgresql.org> <20251019.185323.1616138750375579950.ishii@postgresql.org> To: Tatsuo Ishii X-Mailer: Apple Mail (2.3826.700.81) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 19, 2025, at 17:53, Tatsuo Ishii wrote: >=20 >=20 > If there's no objection, I am going to commit in a few days. > -- > Tatsuo Ishii > SRA OSS K.K. > English: http://www.sraoss.co.jp/index_en/ > Japanese:http://www.sraoss.co.jp > A very trivial commit: ``` + else + + /* + * For other cases we have no idea what position of row = callers would + * fetch next time. Also for relpos < 0 case (we go = backward), we + * cannot set mark either. For those cases we always set = mark at 0. + */ + mark_pos =3D 0; ``` The empty line after =E2=80=9Celse=E2=80=9D is not needed. Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/