KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
plpgsql
29 questions
Follow Tag
Sort by:
Newest
Votes
Active
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