--*Test SQL*
CREATE TABLE tb(id integer primary key,
name varchar(32),
parent integer);
INSERT INTO tb VALUES(1, 'iPhone', NULL);
INSERT INTO tb VALUES(2, 'HTC', NULL);
INSERT INTO tb VALUES(3, 'Motorola', NULL);
INSERT INTO tb VALUES(4, 'iPhone3GS', 1);
INSERT INTO tb VALUES(5, 'G7', 2);
INSERT INTO tb VALUES(6, 'G8', 2);
INSERT INTO tb VALUES(7, 'iPhone4', 1);
INSERT INTO tb VALUES(8, 'iPhone4-white', 7);
INSERT INTO tb VALUES(9, 'iPhone4-black', 7);
INSERT INTO tb VALUES(10,'G7-A', 5);
INSERT INTO tb VALUES(11,'G7-B', 5);
*How to create a SQL to inquiry the result like this:*
id name
----------------
1 iPhone
4 iPhone3GS
7 iPhone4S
8 iPhone4S-white
9 iPhone4S-black
2 HTC
5 G7
10 G7-A
11 G7-B
3 Motorola
Thank you very much!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-inquiry-a-nest-result-tp4981259p4981259.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.