agora inbox for pgsql-docs@postgresql.org  

help / color / mirror / Atom feed

From: yanliang lei <msdnchina@163.com>
To: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: I want  a postgres function to generate ctid where condition for table migration based ctid
Date: Fri, 1 Aug 2025 11:49:03 +0800 (CST)
Message-ID: <143f1cb4.3c39.19863bf61c3.Coremail.msdnchina@163.com> (raw)

for instance,
select * from  tabxxx where  ctid >= '(0,0)' AND ctid <= '(27,0)'
select * from  tabxxx where  ctid > '(27,0)' AND ctid <= '(57,0)'
select * from  tabxxx where  ctid > '(57,0)' AND ctid <= '(69,0)'

and so on


I want to generate a table ‘s  ctid condition automatically

Message-ID: <143f1cb4.3c39.19863bf61c3.Coremail.msdnchina@163.com>
Permalink:  ../143f1cb4.3c39.19863bf61c3.Coremail.msdnchina@163.com/
Also on:    postgresql.org/message-id/143f1cb4.3c39.19863bf61c3.Coremail.msdnchina@163.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: msdnchina@163.com, pgsql-docs@lists.postgresql.org
  Subject: Re: I want  a postgres function to generate ctid where condition for table migration based ctid
  In-Reply-To: <143f1cb4.3c39.19863bf61c3.Coremail.msdnchina@163.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox