The function has two required input tables, vertices and edges. Each row of the vertices table represents a vertex of the graph, and each row of the edges table represents an edge of the graph.
The function has two optional input tables, sources and targets, which specify the vertices that are sources and targets, respectively. For a directed graph, these tables are required. By default, all vertices are sources and targets; that is, the graph is undirected.
pSALSA Vertices Table Schema
Column Name |
Data Type |
Description |
vertex_key_column
|
Any allowed in PARTITION BY clause |
Column that is, or is part of, the unique vertex key. Every column that is part of this key must appear in the PARTITION BY clause. This column cannot contain NULL values. |
pSALSA Edges Table Schema
Column Name |
Data Type |
Description |
source_vertex_key_column
|
Any allowed in PARTITION BY clause |
Column that is, or is part of, the key that identifies the source vertex of the edge. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause. This column cannot contain NULL values. |
target_vertex_key_column
|
Same as data type of source_vertex_key_column
|
Column that is, or is part of, the key that identifies the target vertex of the edge. This key must be a vertex key in the vertices table. This column can contain NULL values. |
edge_weight
|
SMALLINT, INTEGER, or NUMERIC |
Column that contains the weights of the edges, which must be positive values. This column is required only for a weighted graph. This column can contain NULL values. |
pSALSA Sources Table Schema
Column Name |
Data Type |
Description |
source_vertex_key_column
|
Same as data type of corresponding vertex_key_column in vertices table |
Column that is, or is part of, the key that identifies a source vertex. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause. |
pSALSA Targets Table Schema
Column Name |
Data Type |
Description |
target_vertex_key_column
|
Same as data type of corresponding vertex_key_column in vertices table |
Column that is, or is part of, the key that identifies a target vertex. This key must be a vertex key in the vertices table. Every column that is part of this key must appear in the PARTITION BY clause. |