I am using springboot 2.7.4 when I try to connect to Postgres db on azure I met the error org.postgresql.util.PSQLException: FATAL: FIPS cipher suites are enforced for this >server. Please specify FIPS complying cipher suites in your SSL/TLS settings. How…
SELECT * FROM employee WHERE is_deleted != true AND (:lastname IS NULL OR lastname ILIKE '%'||lastname||'%' OR :firstname IS NULL OR firstname ILIKE '%'||:firstname||'%' OR :middlename IS NULL OR middlename ILIKE '%'||:middlename||'%'); I have a full name column and I…
I have this database schema: drop table if exists demo_contact cascade; create table demo_contact (id serial primary key); insert into demo_contact values (1); insert into demo_contact values (2); insert into demo_contact values (3); drop table if exists demo_contact_custom_field cascade; create…
I am using apache age and I have a CSV file with a bunch of data in it. I want to populate my graph using the information in the csv file, so can anyone help me with this, and also…
I have created two vertices, one with label "Book" and another with label "User". The "Book" vertex has a property called "title" and the "User" vertex has the properties "first_name" and "last_name". SELECT * FROM cypher ('goodreads_db', $$ MATCH (v)…
so I have this left join LEFT JOIN LATERAL (SELECT d.country FROM db.patient_info d WHERE d.id IN (SELECT DISTINCT st.category FROM db.surgery_types st, db.surgery_record sr WHERE sr.id = st.surgery_record_id AND sr.surgery_type_id = m.id) ORDER BY d.priority, d.country LIMIT 1 )…
I have a table ,one of the table filed is json format: my_table id json_field 1 { "to_status": 7, "to_status_name": "In Progress", "role": "admin"} 2 { "to_status": 3, "to_status_name": "Completed", "role": "admin"} 3 { "to_status": 2, "to_status_name": "Completed", "role": "customer"}…
This query displays count Actions grouped by day of the week. select count(*) c, date_part('dow', "updatedAt" at time zone 'Europe/Paris') dow from "Action" date_part('dow', "updatedAt" at time zone 'Europe/Paris') Days are displayed as number. Is there a way to display…
My table looks like this: from to status 1 3 invalid 10 15 valid How can I efficiently SELECT or produce a result like this: serial status 1 invalid 2 invalid 3 invalid 10 valid 11 valid 12 valid 13…
I have a table Transactions with id, type, guest_id, timestamp. I want to get the total Car sessions for the last two months. (assuming all transactions with type 'Car' within the same hour from the same guest constitute 1 session).…