sql

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 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…

Here I wanted to insert data in the child table using primary key id of parent table but getting an execution error ERROR: syntax error at or near "int" I want to use IndiaCountry variable in Insert query for this…

I ran and new node application that used a Postgres SQL server. It created a default database called postgres and I wanted to remove it. I used the below command and close the connection and was able to remove that…

I am trying to figure out how to write a single select that would give me all combinations of values for certain aggregations. Let me give you an example of data: COUNTRY PRODUCT VALUE cz p1 5 cz p2 10…