I have no idea why I am having such trouble with this but I can't get this to work properly. I am trying to create a stored procedure that updates a booking datetime for a bookingid of my choice. I…
I am trying to create a pivot table in Postgres from the following table named product_info: CREATE TABLE product_info ( ID varchar(10), date VARCHAR(20) NOT NULL, product VARCHAR(20) NOT NULL, product_cost integer ); INSERT INTO product_info(ID, date, product, product_cost) VALUES…
I'm learning SQL, and I've just learned about inner joins. The thing is, I'd been taught some other way to join tables before, and I don't understand the difference For example, the way I already knew: SELECT E.SALARY FROM EMPLOYEES…
I am trying to obtain the following result: Imagine I have an object table in the following format Name Object id Status A A. . On A B. . Off A C. . Other B D. . On B E.…
Given a table called budgets containing a rate and a time_span I want to generate a monthly daily rate for each day. The time_span must have a start date but can be open ended ["2023-06-02 00:00:00+00",). For example given the…
If I have dates Column and i want to select dates of monday and sunday only from past 1 year, how can i do it with effective code in SQL I tried to select manually the dates but its very…
I'm working with PostgreSQL and I want to enforce a particular column to be unique. But this table has some legacy data in which duplicate of the column are there and they have to be retained unmodified. So when I…
I am still at beginner level on SQL programming so please bear in mind ... My database is similar to the below: +---------------------+------------+--------+------+--+ | Date | FileName | Type | File | | +---------------------+------------+--------+------+--+ | 2023-06-15 08:03:04 | InputParam |…
I'd like to assign type timestamp without timezone to all columns name created_at at my database scheme. I'm trying to run this query: DO $$ DECLARE table_name text; BEGIN FOR table_name IN SELECT table_name FROM information_schema.columns WHERE column_name = 'created_at'…
I have a postgreSQL function which takes a text array as one of the input parameters: CREATE OR REPLACE FUNCTION report.fn_get_metrics( from_date timestamp without time zone, to_date timestamp without time zone, location_ids text[]) RETURNS TABLE(demand_new_count bigint) LANGUAGE 'plpgsql' COST 100…