jeremyforan

{
	"rules": [
		{
			"rule-type": "selection",
			"rule-id": "1",
			"rule-name": "1",
			"object-locator": {
				"schema-name": "%",
				"table-name": "%"
			},

jeremyforan

update dbo.earth set node =
	case
		when node = '\' then '0'
		else '0' || replace(left(node, length(node) - 1 ),'\', '.')
	end;

alter table dbo.earth
alter column node type ltree using node::ltree;

jeremyforan

create schema dbo;

create extension ltree schema public;

create table dbo.earth (
	id serial primary key,
	node character varying(20),
	name character varying(20)
);

jeremyforan

create database migrationdemo;
GO

use migrationdemo
GO

create table earth (
	id int identity(1,1) primary key,
	node hierarchyid,
	name varchar(20)

jeremyforan

package main

import (
	"fmt"
	"math/rand"
	"sync"
	"time"
)

type Message struct {