I'm on Postgres 15.1 and running the following query: EXPLAIN (ANALYZE, VERBOSE) WITH segmented_customer AS (SELECT * FROM customer WHERE integration_id = 162 AND (1 = 1 OR 1 = 1)), segmented_subscription AS (SELECT * FROM subscription WHERE integration_id =…
This is my message table. Now I am trying to write an query to group records by collection_id (only first instance) if type multi-store else by message.id . id | collection_id | type | affiliation_id | status | scheduled_for_date --------------------------------------+--------------------------------------+----------------+----------------+--------------+--------------------…
This is my sample data id|score| --+-----+ 1| 10| 2| 20| 3| 30| 4| 40| 5| 50| 6| 60| 7| 30| 8| 30| 9| 90| 10| 100| My expected output is id|score|_prev_element| --+-----+-------------+ 1| 10| NULL| 2| 20| 10| 3|…
I have a table that records the login information of users on a website, including ID and login date. For example: id user_id date 1 1234 2024-01-01 2 2341 2024-01-07 3 2341 2024-01-13 4 3412 2024-01-20 5 4123 2024-01-20 6…
I tried to create a 1-to-1 relationship in PostgreSQL but when i check the ERD it looks like a 1-to-many relationship. this is my SQL script: CREATE TABLE capital ( id SERIAL PRIMARY KEY, name VARCHAR(100) ); CREATE TABLE country…
I have a Spring boot app with custom queries. I need to find all database rows according to condition - if :myFlag is true, field in database must be in a list (:values here), or null. Can I use something…
I have tried to populate the table but not working this is the code. i am creating a small application to insert delete update my customer management system i have the execution for the records table to get the data…
I want to return all cities whose all postal codes are contained in an array of certain postal codes. On the backend I have an array containing postal codes. The array looks as follows: [41200, 41201, 41202, 42500, 42501, 42504,…
I have the following function that contains a CTE: CREATE OR REPLACE FUNCTION create_job( in_partition_id VARCHAR(40), in_job_id VARCHAR(48), in_name VARCHAR(255), in_description TEXT, in_data TEXT, in_job_hash INT, in_task_classifier VARCHAR(255), in_task_api_version INT, in_task_data BYTEA, in_task_pipe VARCHAR(255), in_target_pipe VARCHAR(255), in_prerequisite_job_ids VARCHAR(128)[], in_delay INT,…
I have data in following format in an SQL table but need to present it differently. Name Property value Mark Gender Male Mark Age 45 Mark Weight 167 Chris Gender Male Chris height 188 I'd very much like to present/select…