I have a use case where i need to split strings by multiple delimiters. client_id blah_blah bleh-bleh select client_id ,split(client_id,'-')[0] col1` ,split(client_id,'-')[1] col2 from mytbl returns Client_id col1 col2 bleh-bleh bleh bleh I have been trying various permutations to get…
I have created scenario in fiddle where I have to remove duplicate records and keep only 1 record example : for spotted table mfg_lz.icc_axbi_kanban_job there are 2 records so need to remove duplicate and keep only 1. select field1 ,unnest(…
I have 3 UPDATE statements (that update more than one column) that I would like to execute against a list of id's without having to run the 3 update statements once by one against each id. Here are the 3…
I'm trying to select rows, where neither A nor B have an entry with more €: This is an example of my data Column A Column B € A B 100 B A 100 C B 80 B C 80…
I am still a novice to SQL, using PostgreSQL 16.2. create table users( user_id serial primary key ); create table task_pool( task_id serial primary key, order_id integer, clicker_id integer, INDEX idx_order_id (order_id) ); create table task_dispersal( id serial primary key,…
IMMUTABLE indicates that the function cannot modify the database and always returns the same result when given the same argument values; that is, it does not do database lookups or otherwise use information not directly present in its argument list.…
I have a simple order table in my postgres db and I want to join from a table of payments to create a new column for each order where the latest payment is indicated. Each payment row looks like this:…
I have a list of ids: select id from id where sid = 2403 The above simply returns a list of ids. e.g. id = 401434786, 401434787, 401434788, etc. When I run one of these ids in my tval table,…
I'm quite new to sql so I don't quite know what is the correct approach to fix my problem. I have two tables, events and labels that have many-to-many relations on id field. i also create junction table for them.…
I've reproduced the issue in a blank project from scratch. Here is a conclusion of the issue I'm encountering: docker-compose.yml version: '3' services: db: image: postgres restart: always volumes: - ./data/db:/var/lib/postgresql/data ports: - 5432:5432 environment: - POSTGRES_DB=testDB - POSTGRES_USER=postgres -…