This is my query: SELECT * FROM profile_change_set where id = '1558079b-d954-4a0d-b241-b39fe8f3498c'; id table_name column_key column_value operation_type 1558079b-d954-4a0d-b241-b39fe8f3498c farmers smsEnabled somvalue update What is want is to convert all values into rows. column_key column_value id 1558079b-d954-4a0d-b241-b39fe8f3498c table_name farmers column_key smsEnabled…
I have a problem with a query to select some data from my database, My database has 3 tables: movies, actors, movies_actors. ACTORS TABLE +-----------+ | ID | NAME | +-----------+ | 1 | Bob | +-----------+ | 2 |…
Will schema-prefixing a stored procedure also limit the scope of all the procedures called inside it to that schema? Take the following scenerio in consideration: Say I have a stored procedure parentProc that calls proc childA childB and childC. This…
I have a custom type in Postgres DB called money_with_currency Created as: CREATE TYPE public.money_with_currency AS (currency_code char(3), amount numeric); We want to change the type of currency_code from char(3) to varchar. I thought the code would be something like:…
I am trying to execute a query with an ORDER BY clause and a LIMIT clause for performance. Consider the following schema. ONE (id, name) (1 , a) (2 , b) (5 , c) TWO (id, name) (3 , d)…
I have these tables: CREATE TABLE tour ( id bigserial NOT NULL, end_date DATE, initial_price float8 NOT NULL, start_date DATE, destination_id int8, guide_id int8, PRIMARY KEY (id) ); CREATE TABLE client_data ( id bigserial NOT NULL, name VARCHAR(255), passport_number VARCHAR(255),…
The problem is if i compare two timestamps and one of them is NULL it chooses Null as higher Value. SELECT case when "Date1" < "Date2" then "Date1" else "Date2" end as "HigherDate" FROM "table" How can i select always…
I need to insert the result of an SQL query into a Postgres table. For that I use ExecuteSQL("Use Avro Logical Types" true) and PutDatabaseRecord("StatementType" INSERT, "Record Reader" AvroReader) processors. The insert doesn’t work because Nifi converts the date to…
I have an annual amount for each subscription with start_date structure; userid startDate(dd-mm-yyyy) amount 1 01-10-2020 120 1 01-10-2021 240 2 01-08-2020 60 I want to divide annual amount to months equally. Output table should be like; userid startDate(dd-mm-yyyy) amount…
I am new to writing postgres queries, I am stuck at a problem where the price is a string having $ prefix, I want to change the data type of column price to float and update the values by removing…