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";
+}