[SQL] Using information_schema to find about function parameters?

I looked at the information_schema.routines, to get information about the functions in the database, but there doesn't seem to be a way to extract the parameters information about functions? Where would I seek for such information? Mike -- Sent via pgsql-sql mailing list

Re: [SQL] Using information_schema to find about function parameters?

Mario Splivalo, 29.10.2009 17:51: I looked at the information_schema.routines, to get information about the functions in the database, but there doesn't seem to be a way to extract the parameters information about functions? Where would I seek for such information? They are stored as an array

[SQL] Speed up UPDATE query?

I'm trying to update several tables (all child tables of the same parent), and as the number of records increases, the length of time it takes to run the update is shooting up exponentially. I have imported the new data to an import table, and then join the import table to the update table. The

[SQL] slow count(CASE) query

Hi all, I have this kind of query that I need to do, yes my query is giving right answers now but it is long and slow. I am now asking you that if you have another solution for my query to make that more smarter ! Hope you can help me with this ! select '000100' as length, sum(ship1) as ship1

Re: [SQL] slow count(CASE) query

Grant Masan wrote: Hi all, I have this kind of query that I need to do, yes my query is giving right answers now but it is long and slow. I am now asking you that if you have another solution for my query to make that more smarter ! Hope you can help me with this ! select '000100' as

Re: [SQL] pg_restore WARNING: errors ignored on restore

Bryce Nesbitt wrote: So when restoring a particular DB with pg_restore, I get WARNING: errors ignore on restore. Is there a way to dump a list of those errors? # /usr/local/bin/pg_restore8.3 -d SUP-3067 -h 192.168.1.93 -p 5433 -U postgres -L toc_with_parts_commented_out.txt -v

Re: [SQL] slow count(CASE) query

Grant Masan wrote: Hi all, I have this kind of query that I need to do, yes my query is giving right answers now but it is long and slow. I am now asking you that if you have another solution for my query to make that more smarter ! Hope you can help me with this ! select '000100'

[SQL] pg_get_functiondef and overloaded functions

Hi, I'm playing around with the new pg_get_functiondef() function but I can't get it to work when I need to specify the argument list. select pg_get_functiondef('foo'::regproc) works without problems. However if I have e.g. foo(int) and foo(int, int) I can't get this to work. I tried

Re: [SQL] pg_get_functiondef and overloaded functions

Thomas Kellerer spam_ea...@gmx.net writes: I tried select pg_get_functiondef('foo(int)'::regproc) select pg_get_functiondef('foo(int4)'::regproc) select pg_get_functiondef('foo(integer)'::regproc) but each time I get the error: function foo(integer) does not exist What am I missing? You