Recent questions tagged plpgsql

0 votes

371 views

1 answer

plpgsql - Return Table Type from A function in PostgreSQL

I have a function from which has a return type as TABLE, and I want to get certain columns from my ... LANGUAGE plpgsql VOLATILE COST 100; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

343 views

1 answer

plpgsql - PostgreSQL 11 - Procedures

With the latest update of PostgreSQL supporting procedures. The official blog, quoted that "As opposed to functions ... argument would be great! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

886 views

1 answer

plpgsql - PostgreSQL GOTO like keyword to jump to a block

I have a PostgreSQL function CREATE OR REPLACE FUNCTION increment(i integer) RETURNS integer AS $$ BEGIN IF i<0 ... a particular code to label. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

313 views

1 answer

plpgsql - PostgreSQL Function / Stored Procedure CURRENT_TIMESTAMP does not change

I want to track the execution time within a function. As an example, I have the following status tracking ... to accomplish this? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

347 views

1 answer

plpgsql - Is it possible to use a variable and not specify a return type in postgreSQL?

Consider this T-SQL: DECLARE @ColorID INT SET @ColorID = 3 SELECT *, left(name,3) FROM Products p WHERE ColorID ... like. Using PostgreSQL 9.4.4 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

381 views

1 answer

plpgsql - PostgreSQL drop constraint with unknown name

I have an SQL script that needs to drop several constraints and restore them at the end, but the constraint ... set. Is this even possible? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

499 views

1 answer

plpgsql - Dynamically generate columns in PostgreSQL

I have seen that there are quit a few similar questions like this one, but I havent understood how to code ... got stucked on previous steps. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

602 views

1 answer

plpgsql - Commit, savepoint, rollback to in PostgreSQL?

Can someone please explain to me why does COMMIT in this function returns EXCEPTION ? DECLARE XNar CURSOR ( ... block exists in function? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

404 views

1 answer

plpgsql - Hashing a String to a Numeric Value in PostgreSQL

I need to Convert Strings stored in my Database to a Numeric value. Result can be Integer (preferred) or Bigint. ... anything useful so far :( See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

996 views

1 answer

plpgsql - PostgreSQL equivalent of Oracle "bulk collect"

In PostgreSQL exists some ways to make a statement using bulk collect into like in Oracle? Example in Oracle: create or ... = 1 end; Thank you See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

472 views

1 answer

plpgsql - Return SETOF rows from PostgreSQL function

I have a situation where I want to return the join between two views. and that's a lot of columns. It was ... execute (SqlString ); END; $BODY$ See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags