In this code, when I run: CREATE TABLE IF NOT EXISTS setup_workspace_result ( path TEXT, workspace_id BIGINT ); DROP FUNCTION IF EXISTS public.setup_workspace; CREATE OR REPLACE FUNCTION setup_workspace(refresh_token TEXT) RETURNS setup_workspace_result AS $$ DECLARE user_email TEXT := ((current_setting('request.jwt.claims'::text, TRUE))::JSON ->>…
Here's a view with a hard-coded equality: create or replace view v1 as select * from mytable where x=3; Is it possible create a "parameterized" equivalent of this in Postgresql? create or replace SOMETHING v2(value) as select * from mytable…
I'm a beginner in SQL and I tried looking for an answer without any luck. I would like to generate invoice numbers automatically with the following distinctions: I have 2 different structures invoicing I would like to avoid any numbering…
I want to get records from Leads table by applying where condition(e.g when LSH.status=5) should apply on only on top first record(i made LSH.leads_status_id DESC) from table leads_status_history, how to filter the records ? But currently by using below sql…
I get an Error because of the Check Constraint and i dont know why. create table TStudenten ( StudId int unsigned auto_increment primary key, StudVorname varchar(25) not null, StudNachname varchar(25) not null, StudStrasse varchar(40), StudPLZ char(4), StudOrt varchar(20), StudGebDatum date,…
I have this table (simplified version): id state place temp 1 AA PLC1 10 2 AA PLC2 20 3 AA PLC3 25 4 EE PLC4 11 5 EE PLC5 15 6 EE PLC6 19 . .. .... .. How to…
Postgres version: 13.2 We have a complex query to get a list of decks in production and we experience slow response time. Here is the content of the function. I have hardcoded the 4 arguments of the function to get…
I have the following sample data Sample Data I want to get the latest mark for each student. Take Note that the column named Exam marks whether the work was an Exam or Not. I want to get the latest…
I have the following sample data: create table employee (id int,emp_name varchar(50),project_name varchar(50)); insert into employee(id,emp_name) values(1,'Smith'); insert into employee(id,emp_name) values(2,'Jill'); insert into employee(id,emp_name) values(3,'Hana'); create table employee_project (emp_id int,project_id int); insert into employee_project(emp_id,project_id) values(1,101); insert into employee_project(emp_id,project_id) values(2,201); insert…
I am trying to find a way to delete all rows with NULL values in a table. On this post, I saw that you can't specify a target table from updates in the FROM clause. Therefore, I tried building a…