I have the below table - assume tags column always have top level string keys: name(TEXT) | tags(jsonb) -----------+------------------------------------------------------- teamA | {"color": "green", "zone": "primary"} teamB | {"color": "green", "zone": "primary", "role": "user"} teamC | {"uid": "32-232-2dswdwsd", "availability": "condensed"} Let's…
I have PostgreSQL 15 running with the Apache AGE extension installed on it. I can view graphs and run queries using AGE Viewer, but I get the following error when creating a new graph from AGE Viewer. I restarted AGE…
I'm adding temporal Cypher functions to AGE, and I've implemented the date() Cypher function. Currently, it works, and my result is printed in the output as a string. SELECT * FROM cypher('graph', $$ RETURN date() $$) as (date agtype); date…
I'm trying to "copy/paste" rows of a table with bigserial id column, without listing all columns names in the query. There is a related post https://stackoverflow.com/a/15344327, which does not work with psql. The isses is that psql does not trigger…
I have a postgres database where I use ef to control my migrations code first. I currently have this table/class. public class Notification { [Key] public Guid Id { get; set; } = Guid.NewGuid(); public string ActionType { get; set;…
I following a tutorial and had this problem, but seems like it was only me.. Everytime i'm trying to run this i have the same output. Please help im trying to connecting backend to the database This is my server.js…
I am trying to run AgensBrowser on my Windows machine, I have already installed AgensGraph. First, I registered in the official website and was sent a link to download the Zip file, I extracted the contents in the Zip file…
Doing self join with same table with range condition. The below is sql statement. select current_rec .* ,compare_rec.employee_id as less_salary_employee from hr.employees current_rec left join hr.employees compare_rec on current_rec.hire_date < compare_rec .hire_date and current_rec.salary < compare_rec.salary order by current_rec .employee_id…
I have two tables which I want to left join. One with dates ranging between 2 Augustus 2023 - 10 augustus 2023. I want to join this with my ad interaction table. The Ad interaction table only has interactions from…
I have a table that looks something like this: id colors other column other column 1 red, green, blue ... ... 2 red, blue ... ... 3 red ... ... 4 white, blue, purple ... ... 5 green, white, purple…