I have a question, what is missing or wrong in the RETURN statement that it keeps crashing error 2F005 I am creating a table to log errors drop table if exists public.funkcja_x; create table public.funkcja_x ( error_alert text ); I…
I have 2 tables with a foreign key. I have to get the counts of all the records in right table and the threshold value of max ts in right table. TABLE alarm column Datatype id PK name varchar TABLE…
I have deep learning models (tensorflow in hdf5 format), which I want to upload to a PostgreSQL database. A single model may be up to 500 MBs, and the models need to be updated and uploaded/downloaded from the database frequently…
From a PostgreSQL article on foreign keys constraints at https://www.postgresql.org/docs/current/ddl-constraints.html: Say you have the product table : CREATE TABLE products ( product_no integer PRIMARY KEY, name text, price numeric ); Let's also assume you have a table storing orders of…
I am trying to extract words from a column in a table only if the entire word is in uppercase letters (I am trying to find all acronyms in a column). I tried using the following code, but it gives…
I have been reading Jasper Blues' blog post : ROCK ’N’ ROLL TRAFFIC ROUTING, WITH NEO4J but I wanted to port it to AGE. He makes a graph with multiple vertices labeled as Metro and each vertex is connected to…
I don't get why when I SELECT pizzeria_name and person_name in FROM nested query it doesn't work but when I put (*) instead i see two columns displayed on the screen with names person_name and pizzeria_name. How can i substitute…
I have two tables that have a parent/child relationship, where one record in the parent table may correspond to N records in the child. Both tables have an amount column that I want to aggregate in one query, so I…
Example at Oracle: explain plan for select * from sample_table where column_name = :1 This will return query plan with detailed steps and cost in a tabular form. Example at PostgreSQL explain (format yaml) select * from sample_table where column_name…
I'm working with a few large row count tables with a commonly named column (table_id). I now intend to add an index to this column in each table. One or two of these tables use up 10x more space than…