summaryrefslogtreecommitdiffstats
path: root/contrib/seg/sort-segments.pl
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/seg/sort-segments.pl')
-rwxr-xr-xcontrib/seg/sort-segments.pl30
1 files changed, 30 insertions, 0 deletions
diff --git a/contrib/seg/sort-segments.pl b/contrib/seg/sort-segments.pl
new file mode 100755
index 0000000..67a227b
--- /dev/null
+++ b/contrib/seg/sort-segments.pl
@@ -0,0 +1,30 @@
+#!/usr/bin/perl
+
+# Copyright (c) 2021-2022, PostgreSQL Global Development Group
+
+# this script will sort any table with the segment data type in its last column
+
+use strict;
+use warnings;
+
+my @rows;
+
+while (<>)
+{
+ chomp;
+ push @rows, $_;
+}
+
+foreach (
+ sort {
+ my @ar = split("\t", $a);
+ my $valA = pop @ar;
+ $valA =~ s/[~<> ]+//g;
+ @ar = split("\t", $b);
+ my $valB = pop @ar;
+ $valB =~ s/[~<> ]+//g;
+ $valA <=> $valB
+ } @rows)
+{
+ print "$_\n";
+}