Using the vertex_stats() on the vertex of a graph we can load the contexts of the vertex in the graph. Where are they stored when they are loaded and what is the exact use of having the "stats" loaded? And…
For example, I have this table that contains two specific brands - 'Ford' and 'Subaru', which just so happen to be the top earning brands for the Eastern and Western markets respectively. To obtain this info, I make a view:…
Why is the below code not valid. I have only used immutable columns. Below code is supposed to add a new column to the users table. There are few conditions that needs to meet for the is_valid column to be…
I built a dynamic query that returns Total count of entries in CTE Paginated entries from CTE List of column names used in CTE Requested page size and page number The beauty of in returning total count + pagination in…
Apache AGE gives the following way of obtaining path from one vertex to the other through variable number of intermediary nodes. (u)-[*3..5]->(v) I tried the following query in Apache AGE and it indeed does give the desired result. test=# SELECT…
I have a users table, with the primary key being an id field, which is an autoincrementing integer. I don't have a username field right now, but I would like to add one. Now, the username should be UNIQUE and…
I have a graph for cities with 6 cities, and only two of them have a relationship between them. I would like to write a query that gives me all the cities along with all the relationships in between them.…
I am trying to match nodes a where the sizes for a.category are less than or equal to 9. I would like to place a condition for a.category sizes that are exactly the size of 9, that only the nodes…
I use the query string: INSERT INTO public.owner (name, address, public_key) VALUES ('name1', 'address4', 'publicKey1'), ('name1', 'address5', 'publicKey2'), ('name1', 'address6', 'publicKey3') ON CONFLICT (address, public_key) DO NOTHING; And I got an error message: ERROR: there is no unique or exclusion…
I translate t-sql code to PostgreSQL. I have temp table, which structure i can't change. This table have only index without PK. In t-sql to update columns in this table i using this: update t set col_1 = tt.val from…