Tang Hoai Nam NamTang

Java developer

dankrause / postgresql_recursive.sql

Last active March 6, 2025 20:15

An example of creating a recursive postgresql query to generate data about parent-child relationships within a single table.

	CREATE TABLE test
	(
	id INTEGER,
	parent INTEGER
	);


	INSERT INTO test (id, parent) VALUES
	(1, NULL),
	(2, 1),