태그: plpgsql

AgensGraph: graph sampling with random selection

In the previous post, we did make ag_labels() function by #plpgsql. In this time, we will make ag_sample() function that do sampling graph-data by limit N on an edge basis. Also this function has the optional parameter of whether using random-selection. PL/pgSQL is a loadable procedural language for the PostgreSQL database system. [ref] It adds ...

How to make ag_labels() function in AgensGraph

AgensGraph is a Graph DB of Labeled Property Graph model. It has label data for presenting vertices, edges. If you want to see labels list, you should type ‘\dGl’ on AgensGraph console. (article quick-guide-2-1) Meta Command \dG[+] [PATTERN] list graphs \dGe[+] [PATTERN] list graph edge labels \dGl[+] [PATTERN] list graph labels \dGv[+] [PATTERN] list graph ...