Re: [GENERAL] How to inquiry a nest result?

Appreciate for your help ! -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-inquiry-a-nest-result-tp4981259p4984218.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] How to inquiry a nest result?

--*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);

Re: [GENERAL] Whether the function exists a in pgsql table or not?

My friend, thanks for your replay, however how to prove your view? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Whether-the-function-exists-a-in-pgsql-table-or-not-tp4741670p4749963.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent v

[GENERAL] Whether the function exists a in pgsql table or not?

In Oracle, when the table has few records, used frequently, it would use "storage(buffer_pool keep)" to keep the data in cache instead of LRU algorithm. if the function exists in a pgsql table or not? -- View this message in context: http://postgresql.1045698.n5.nabble.com/Whether-the-function-