All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
36 views

postgresql v8.4 function runs but doesn't work

I have a postgresql v8.4 database. I need to update several hundred tables with about 3 million rows of data each. The customer wants a new column added (which I added) and now I'm trying to update ...
1
vote
2answers
10k views

Declare variable for SELECT statement in Postgres function

I have modified my function, but I have problems with declaring variables. I use Postgres 8.4. CREATE OR REPLACE FUNCTION requestcounterid(_mindate timestamptz, _maxdate timestamptz) RETURNS TABLE ...
64
votes
2answers
68k views

Create index if it does not exist

I am working on a function that allows me to add an index if it does not exist. I am running into the problem that I cannot get a list of indexes to compare to. Any thoughts? This is a similar issue ...
6
votes
1answer
4k views

PostgreSQL 8.4: How to tell if a procedural language is installed or not?

I have a setup program that requires plpgsql to install stored procedures in a PostgreSQL 8.4 database. I need to make sure the language is installed or the app will fail. I don't want to drop the ...