Questions tagged [plpgsql]

10

votes

3

answers

postgres. plpgsql stack depth limit exceeded

postgresql plpgsql

asked 2013-05-22T16:15:49.043

40

votes

2

answers

Loop on tables with PL/pgSQL in Postgres 9.0+

postgresql variables loops plpgsql tablename

asked 2013-03-07T08:26:37.277

177

votes

5

answers

How to create function that returns nothing

database postgresql plpgsql void

asked 2013-01-08T14:09:04.170

16

votes

2

answers

Incrementing a number in a loop in plpgsql

sql postgresql increment plpgsql postgresql-8.4

asked 2012-12-07T20:58:08.940

18

votes

2

answers

Postgres function with list argument and in clause

sql function postgresql plpgsql

asked 2012-10-18T13:39:31.317

25

votes

3

answers

Raising error in postgreSQL

postgresql plpgsql quoting

asked 2012-09-21T10:48:39.700

17

votes

1

answers

How to execute PostgreSQL RAISE command dynamically

postgresql exception plpgsql

asked 2012-08-11T19:02:30.080

14

votes

3

answers

PL/pgSQL SELECT into an array

sql postgresql plpgsql postgresql-9.1

asked 2012-07-31T00:19:11.280

34

votes

1

answers

Postgres trigger after insert accessing NEW

sql postgresql triggers plpgsql

asked 2012-06-12T16:49:40.137

9

votes

9

answers

Javascript encodeURI like function in postgresql?

postgresql stored-procedures urlencode plpgsql

asked 2012-04-25T14:39:53.663

36

votes

2

answers

Return value from anonymous function postgresql

postgresql anonymous-function plpgsql

asked 2012-04-25T11:48:16.607

174

votes

3

answers

How to return result of a SELECT inside a function in PostgreSQL?

sql database postgresql plpgsql return-query

asked 2011-10-30T15:47:53.953

66

votes

7

answers

DROP FUNCTION without knowing the number/type of parameters?

sql postgresql plpgsql dynamic-sql ddl

asked 2011-10-01T20:54:07.897

55

votes

4

answers

The forgotten assignment operator "=" and the commonplace ":="

postgresql plpgsql assignment-operator colon-equals

asked 2011-09-18T15:02:29.963

27

votes

2

answers

array_length() of an empty array returning NULL

arrays postgresql plpgsql

asked 2011-08-08T16:33:48.993

152

votes

6

answers

Store select query's output in one array in postgres

sql arrays postgresql plpgsql

asked 2011-06-19T11:15:59.607

12

votes

3

answers

PHP array to postgres array

php arrays postgresql plpgsql

asked 2011-04-12T06:47:30.370

16

votes

4

answers

PostgreSQL function or stored procedure that outputs multiple columns?

postgresql stored-procedures plpgsql sql-function

asked 2011-03-28T17:49:30.633

16

votes

1

answers

Any difference in performance/compatibility of different languages in PostgreSQL?

database postgresql stored-procedures plpgsql

asked 2010-12-25T23:59:21.640

15

votes

1

answers

plpgsql function returns table(..)

postgresql plpgsql

asked 2010-11-25T18:18:55.073

237

votes

14

answers

Truncating all tables in a Postgres database

postgresql plpgsql dynamic-sql truncate database-table

asked 2010-05-13T18:04:15.787

12

votes

1

answers

Query has no destination for result data after trigger

database postgresql triggers plpgsql

asked 2010-04-30T10:56:59.323

10

votes

3

answers

Create a schema with the name passed by variable

postgresql plpgsql

asked 2010-03-05T07:13:42.223

14

votes

2

answers

PostgreSQL - Language pgplsql does not exist despite running CREATE LANGUAGE

postgresql plpgsql

asked 2010-01-23T05:09:51.803

12

votes

2

answers

ERROR: query has no destination for result data

postgresql plpgsql

asked 2010-01-18T10:52:18.033

15

votes

3

answers

Inserting NEW.* from a generic trigger using EXECUTE in PL/pgsql

postgresql triggers plpgsql

asked 2010-01-04T03:12:30.577

13

votes

3

answers

How do I write a postgres stored procedure that doesn't return anything?

postgresql stored-procedures plpgsql

asked 2009-08-27T21:55:31.033

96

votes

11

answers

How do I get the primary key of a table from Postgres via PL/pgSQL?

sql postgresql plpgsql

asked 2009-07-31T20:01:45.727

9

votes

7

answers

Session based global variable in Postgresql stored procedure?

oracle-database postgresql plsql plpgsql

asked 2009-01-05T21:09:59.457

Questions tagged plpgsql