I need to select from a table (user_id, i_id) only those values that match both user_ids. Table structure: user_id i_id 713870562 2 713870562 3 713870562 4 713870562 5 713870562 6 713870562 7 713870562 8 713870562 9 22131245 6 22131245 7…
Tell me how to optimize the deletion of data from a Postgre table I have a table like this: CREATE TABLE IF NOT EXISTS test ( group varchar(255), id varchar(255), type varchar(255), ); INSERT INTO test (group, id, type) VALUES…
I would like to check an input (parameter) of a stored procedure if it has many spaces and empty, not just 1 space like so: ' ' '. I tried : IF column IS NULL or TRIM(column IS NULL) THEN…
Context of the problem - I want to migrate from the SQLite database to Postgres. When I makemigrations with Postgres settings which are passed to the settings file with environment variables, I get KeyError; however, another variable from the same…
Iam using the row level security in supabase with nest.js, So how can I set runtime variables safely to the DB so that I can be sure that the variables sync with each app user (due to the http request…
I have a table A and in it I have a column of type json that receives an array of dates. I need to fetch all female records from table A. I need to return a specific date from each…
In PostgreSQL 11, I am trying to get a weekend time range. From 17:00 Friday to Sunday 17:00. So far I am able to get a working day by doing select * from generate_series(date '2021-01-01',date '2021-12-31',interval '1' day) as t(dt)…
I am looking to build a filter component where my search comes like b_cycle_type = '1st Day Of The Month' and in the database b_cycle_type is stored as -1,0,1,2,3,4,5 How can I prepare postgres statement I am trying: SELECT "customers".*…
I seem to have relatively easy question, but I have a little problem. I would like to iterr through the column prices in table products and then sum the prices. I know an easy solution would be to change sql…
I've a JSONB inside a PostgreSQL table with this structure (more or less) { "obj1": { "obj2": { "obj3": [ { "obj4": { "obj": "A" } }, { "obj4": { "obj": "B" } } ] } } } Then my…