I'm encountering an issue while trying to insert an array of strings into a PostgreSQL database column. The column is defined as follows: path TEXT[] NOT NULL here is the schema: path: { type: 'array', items: { type: 'string' },…
i started learning clojure, and i have one problem. I just have 2 files, project.clj (defproject test-clojure-project "0.1.0-SNAPSHOT" :description "A simple Clojure web project" :dependencies [[org.clojure/clojure "1.10.0"] [ring "1.10.0"] [ring/ring-jetty-adapter "1.10.0"] [ring/ring-json "0.5.0"] [cheshire "5.10.0"] [org.postgresql/postgresql "42.3.1"] [org.clojure/java.jdbc "0.7.11"] ;;…
very very new here and to PGSQL creating an app using flutterflow. I am trying to create a trigger function that will update a coloumn called 'holes' when a new row is added to the scorecard table using a subquery…
I have to create plpgsql function for generation sequence number considering some doc_id argument. I wrote a function, but when I run it I get error [42601] ERROR: query has no destination for result data Where: PL/pgSQL function create_sequence_number(text) line…
I have a query: SELECT … FROM … WHERE project = 123 AND ( file = file1 and fieldidx = idx1 OR file = file2 and fieldidx = idx2 OR …) … I want to create the where clause in…
I have a COLUMN in a Postgres table which has values with the following pattern. INPUT-X INPUT-X-Y INPUT-X-Y-Z INPUT-X-Y-Z-A-... I am trying to count the number of entries in COLUMN where the value begins with INPUT and contains a given…
I need to fill .env with production or test environment multiline data I try to fill it in Dockerfile as follow below CMD echo -e ${ENV_DATABASE_URL} > /var/www/.env CMD echo -e ${ENV_LOGIN_USER_ID} >> /var/www/.env command cat .env printout will be…
I created a table for to store day off data of users. After, set a unique index for multi column but when exec insert sql, it duplicates datas again Here's my DDL: create table day_off_movements ( id bigserial primary key,…
I'm trying to figure out a way to reason about a fairly simple problem: A table foo has two columns, id with unique identifiers, and value with a random numeric value. Given a constant threshold value, find the groups of…
Pgsql Version : 10.21. We are consistently receiving below message in the pg_log. 'using stale statistics instead of current ones because the stats collector is not responding' Moreover, we have noticed significant slowdowns in DB queries occurring randomly. Anybody faced…