Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nuEVS-0005oM-3K for pgsql-docs@arkaria.postgresql.org; Thu, 26 May 2022 14:30:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nuEVP-0003eG-Uw for pgsql-docs@arkaria.postgresql.org; Thu, 26 May 2022 14:30:27 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nuEVP-0003e7-LR for pgsql-docs@lists.postgresql.org; Thu, 26 May 2022 14:30:27 +0000 Received: from mail-lj1-x22f.google.com ([2a00:1450:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nuEVL-00033k-LO for pgsql-docs@lists.postgresql.org; Thu, 26 May 2022 14:30:26 +0000 Received: by mail-lj1-x22f.google.com with SMTP id r3so1945559ljd.7 for ; Thu, 26 May 2022 07:30:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=lKcGVWjF2ETFsF4k1QrMEJWdCdsQlLtTWifVXIO7hM4=; b=qZBOW7gLG34au9l/Mnw1WVP4bvcPyX1Q+oSCuB7hZZ1ScQwEIj7RCg4P6VQ32luhLZ QPmktXNGUfH/veT462zVT8YIOpG3zE05zf8G5KMpdwiEqsYDrQpcrbElHYiShm94Bjz5 LU1JV4IUdr9Z7xe+TollFHmlPHSN450xlM5oTHnWV8NOUAH5l76fBTxWO6dPCXWYYObP vP9eMZ6LA5wfGuZjhl9bIklilY0ncCQ11AsBO5c6Ro865bJf1vKutB4SI6Nm/+K9bSFn lo4lHpi6clb0LwS/X13w4OOxqX1JVhyDYA7XXbZUwFpDJAbydXC9qzyI+dYVbA1dsu0/ NkQQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=lKcGVWjF2ETFsF4k1QrMEJWdCdsQlLtTWifVXIO7hM4=; b=7lRVdusYPVgf1J89BP6mGpGDbzNhGw1n2DJP1C2qXYV0E5bYJ0mbZlefFCBjpSBUa8 p3fxQzK+MeUVCG7kgjERf6vaaFzJ5HridemUWW9Md3TcAFKnl+lmLfvZLOxihbhnkWzA QOFr0LJvF3Cn+WB/sPDFFHd5zwMiWb3CHIfFrpntNDxbjnRdbkuoU7qx/Yeaq7q/VmO7 AqRVf4tOUDyZYfSRiBbiUDN7enWCZ2xYJXO99YVayoadd5m9HHqLLypw/nllE4hIXtbS JE8J9Wxo9DgN7hQqyNIE5HwuVstynA2iZjtCNkZHPrhxA/Zoo/Lb9oADaPwItBAlTPtP TBrw== X-Gm-Message-State: AOAM531iHtiXL133rRAgEwsNvFLH7z1R+2Tj8MMFYLDwQwRKQwJkqbPl +I+BcwU2AlABhcsnQ5aQReK12ea+SZzMPHFLyX5hqtHnb3hpzQ== X-Google-Smtp-Source: ABdhPJyAI/jfIlbe4Rm/zQSCLGDj8OVNTvhRB0fqvysMo/UdHIhM8jft/cWQS0Tn5cYah5Zh1PxtPZwuIUdDRDmnVis= X-Received: by 2002:a2e:b00f:0:b0:253:ef08:a68b with SMTP id y15-20020a2eb00f000000b00253ef08a68bmr10781893ljk.279.1653575421116; Thu, 26 May 2022 07:30:21 -0700 (PDT) MIME-Version: 1.0 From: jian he Date: Thu, 26 May 2022 20:00:09 +0530 Message-ID: Subject: collation.html natural sort To: pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000095c42905dfeb0766" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000095c42905dfeb0766 Content-Type: text/plain; charset="UTF-8" https://www.postgresql.org/docs/15/collation.html > Numeric ordering, sorts sequences of digits by their numeric value, for > example: A-21 < A-123 (also known as natural sort). > I guess maybe it should be 'A-21' < 'A-123' ? -- I recommend David Deutsch's <> Jian --00000000000095c42905dfeb0766 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Numeric ordering, sorts sequences of digits by their numeric value, for example: A-21 < A-123 (also known as natural sort). =20

I guess maybe it should be=C2=A0 'A-2= 1' < 'A-123' ?


--
=
=C2=A0I recommend David Deutsch's <<The Beginning= of Infinity>>

=C2=A0= Jian


--00000000000095c42905dfeb0766--