I am creating a new AGE CLI using lex/yacc, Makefiles, and several PostgreSQL files (project link). When executing the created interface ./agesql (similar to bin/psql for postgres) and entering a backslash command, I get the error: ERROR: /* error message…
I am new to databases in general and I need some help with user privileges. I created a desktop application in C# that uses npgsql to connect to my PostgreSQL database. Every command to the database is either a function…
I'm looking to get a list of all messages between users but only the latest message sent by either user A or user B in the database these fields are fromUser and toUser I need a list of the latest…
I have such table (simplified) id pos neu neg x 1 2 3 y 4 2 1 z 1 5 2 I use PostgreSQL and my goal is to get greatest value for each row, so i use next query:…
I am writing a SQL query. It's a very complex query. But here I in this question, I will only extract out the part that I am struggling to make it easier to explain what I am struggling with. I…
I have two tables table_a and table_b in a Postgresql 13 database, having UUIDs primary key columns. table_a has multiple entries, whereas table_b is empty (no entry). The following query returns the expected result, namely entry_count_a larger than 0: SELECT…
I am trying to detect cycles in a graph created on postgreSQl and Apache AGE using WITH RECURSIVE method. Can someone guide me why my cypher query would not be able to detect cycles? I have using this reference. Below…
I need some help. I have a table in PostgreSQL with logs of user sessions. The table has 3 fields: id, action, and action_date in the timestamp format. The action field has 2 possible values: "page_load" or "page_exit". The action_date…
I am connecting the instance of AGE running on WSL to AGE Viewer running on Window. It is working fine. When I run query: SELECT * FROM cypher('university', $$ MATCH (v) RETURN v $$) as (v agtype); It works fine…
I'm using psycopg2 python3 library to connection to my heroku postgreSQL database. Heroku provided me with database url, I store it in DATABASE_URL environmental variable. I'm trying to locally connect to DB and execute some queries. But it seems like…