StackOverflow Questions for Tag: plpgsql

rlib

Reputation: 7897

Returning dynamic query results from PL/PGSQL function, multiple rows

postgresqlplpgsqldynamicquery

Score: 0

Answers: 2

user2465039

Reputation: 965

Parallel safety and exception handling in Postgres

postgresqlplpgsql

Score: 2

Answers: 1

Tim Kane

Reputation: 2779

Count previous rows within range

sqlpostgresqlplpgsqlcommon-table-expressionwindow-functions

Score: 5

Answers: 2

Pavel Murnikov

Reputation: 113

Postgres INSERT text column accepts only numeric characters convertible to bigint

postgresqlplpgsql

Score: 0

Answers: 1

Reikryv

Reputation: 1

How to run a function without storing it postgresql

sqlpostgresqlplpgsql

Score: 0

Answers: 2

Andrus

Reputation: 27955

How to create operator if not exists

sqlpostgresqloperator-overloadingplpgsql

Score: 0

Answers: 1

Richard Hum

Reputation: 651

I want to have my pl/pgsql script output to the screen

postgresqlfor-loopplpgsql

Score: 3

Answers: 2

Louis93

Reputation: 3921

How do I pass in a table parameter to this function?

postgresqlcastingplpgsql

Score: 4

Answers: 2

Johny T Koshy

Reputation: 3922

Error while trying to insert data into timestamp field using plpgsql

postgresqltimestampplpgsql

Score: 0

Answers: 1

GT.

Reputation: 1170

PSQL Command Line Arguments in DO script

postgresqlcommand-lineparameter-passingplpgsqlpsql

Score: 3

Answers: 2

jean-yves boisiaud

Reputation: 49

in a trigger, how to use NEW for a dynamic query?

postgresqlplpgsql

Score: 2

Answers: 1

CQM

Reputation: 44278

Send variables to a function, casting?

sqlpostgresqlplpgsqlpostgresql-8.4

Score: 3

Answers: 2

jjm

Reputation: 6198

Returning boolean from SQL function

sqlpostgresqlstored-proceduresplpgsql

Score: 8

Answers: 1

ufk

Reputation: 32134

why functions that returns tables are so much slower then running the actual query?

postgresqlplpgsql

Score: 0

Answers: 1

Raghugovind

Reputation: 3

Postgres cursor is not taking multiple parameters

postgresqlplpgsqldatabase-cursor

Score: 0

Answers: 1

ryan

Reputation: 99

Creating a specific exception for a function in PL/PgSQL

postgresqltriggersplpgsql

Score: 0

Answers: 1

Peter Sun

Reputation: 1825

Update every N rows with an increment of 1

sqlpostgresqlplpgsqlwindow-functionspostgresql-9.3

Score: 1

Answers: 1

Anastasia Kar

Reputation: 33

ERROR: query has no destination for result data HINT: If you want to discard the results of a SELECT, use PERFORM instead

postgresqlplpgsql

Score: 0

Answers: 1

Harvey Adcock

Reputation: 971

Why does this multiple "DO" block script work in DBeaver but fail in pgAdmin?

postgresqltransactionsplpgsqlpgadmin

Score: 0

Answers: 2

thor

Reputation: 22530

How to return a table by rowtype in PL/pgSQL

postgresqlpolymorphismplpgsqldynamic-sql

Score: 3

Answers: 1

PreviousPage 1Next

StackOverflow Questions for Tag: plpgsql

Returning dynamic query results from PL/PGSQL function, multiple rows

Parallel safety and exception handling in Postgres

Count previous rows within range

Postgres INSERT text column accepts only numeric characters convertible to bigint

How to run a function without storing it postgresql

How to create operator if not exists

I want to have my pl/pgsql script output to the screen

How do I pass in a table parameter to this function?

Error while trying to insert data into timestamp field using plpgsql

PSQL Command Line Arguments in DO script

in a trigger, how to use NEW for a dynamic query?

Send variables to a function, casting?

Returning boolean from SQL function

why functions that returns tables are so much slower then running the actual query?

Postgres cursor is not taking multiple parameters

Creating a specific exception for a function in PL/PgSQL

Update every N rows with an increment of 1

ERROR: query has no destination for result data HINT: If you want to discard the results of a SELECT, use PERFORM instead

Why does this multiple &quot;DO&quot; block script work in DBeaver but fail in pgAdmin?

How to return a table by rowtype in PL/pgSQL

Why does this multiple "DO" block script work in DBeaver but fail in pgAdmin?