python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - plpgsql

Checking Function Parameter Postgres

i'm trying to find the fastest way to check whether my postgres function parameter is null or empty. my current function looks like: CREATE OR REPLATE FUNCTON update_seller_detail(seller_id int, sell...
test-img

Yohanes Lim

postgresql

user-defined-functions

plpgsql

Votes: 0

Answers: 1

Latest Answer

you can use coalesce(nullif(trim(<column-reference>), '') in update query with column reference: CREATE OR REPLACE FUNCTION update_seller_detail( seller_id int, seller_name varch...
test-img

Pooya

Postgresql Function for Inserting Data With Join

i tried to do create postgres sql function to insert data from parameter that given in the function. For example There are 2 tables: Table Customer Customer customer_id customer_name customer_phone T...
test-img

Yohanes Lim

sql

postgresql

plpgsql

Votes: 0

Answers: 0

Declare and return value for DELETE and INSERT

I am trying to remove duplicated data from some of our databases based upon unique id's. All deleted data should be stored in a separate table for auditing purposes. Since it concerns quite some datab...
test-img

Bobstar

postgresql

sql-insert

plpgsql

sql-delete

dynamic-sql

Votes: 0

Answers: 3

Latest Answer

You need to create and then call a plpgsql procedure with input parameters : CREATE OR REPLACE PROCEDURE duplicates_suppress (my_target_schema text, my_source_schema text, my_source_table text, unique...
test-img

Edouard

How to update all constraints referencing some field? For loop execute plpgsql

I want to update several constraints to cascade on delete or update. I know there are going to be major changes to "field_z" in "my_table", and many other fields in my database are...
test-img

Chad S

postgresql

plpgsql

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs