Re: [GENERAL] PLPGSQL function to search function source for a list of terms

2010-09-17 Thread bricklen
On Fri, Sep 17, 2010 at 10:17 AM, bricklen wrote: > On Fri, Sep 17, 2010 at 10:16 AM, Raymond O'Donnell wrote: >> On 17/09/2010 18:12, bricklen wrote: >>> >>> On Fri, Sep 17, 2010 at 9:57 AM, Raymond O'Donnell  wrote: That could be pretty useful - why don't you put it on the wiki?

Re: [GENERAL] PLPGSQL function to search function source for a list of terms

2010-09-17 Thread bricklen
On Fri, Sep 17, 2010 at 10:16 AM, Raymond O'Donnell wrote: > On 17/09/2010 18:12, bricklen wrote: >> >> On Fri, Sep 17, 2010 at 9:57 AM, Raymond O'Donnell  wrote: >>> >>> That could be pretty useful - why don't you put it on the wiki? >>> >>> Ray. >>> >> I was going to put an entry at >> http://wi

Re: [GENERAL] PLPGSQL function to search function source for a list of terms

2010-09-17 Thread Raymond O'Donnell
On 17/09/2010 18:12, bricklen wrote: On Fri, Sep 17, 2010 at 9:57 AM, Raymond O'Donnell wrote: That could be pretty useful - why don't you put it on the wiki? Ray. I was going to put an entry at http://wiki.postgresql.org/wiki/Category:Library_Snippets, but I couldn't find the "edit" option.

Re: [GENERAL] PLPGSQL function to search function source for a list of terms

2010-09-17 Thread bricklen
On Fri, Sep 17, 2010 at 9:57 AM, Raymond O'Donnell wrote: > That could be pretty useful - why don't you put it on the wiki? > > Ray. > I was going to put an entry at http://wiki.postgresql.org/wiki/Category:Library_Snippets, but I couldn't find the "edit" option. Maybe I'm blind? I just noticed h

Re: [GENERAL] PLPGSQL function to search function source for a list of terms

2010-09-17 Thread Raymond O'Donnell
On 17/09/2010 17:37, bricklen wrote: Here is a plpsql function I put together to search db functions in schemas other than pg_catalog and information_schema. Not the greatest of coding, but it might help someone else trying to solve the same issue I was having: to search all public functions for

[GENERAL] PLPGSQL function to search function source for a list of terms

2010-09-17 Thread bricklen
Here is a plpsql function I put together to search db functions in schemas other than pg_catalog and information_schema. Not the greatest of coding, but it might help someone else trying to solve the same issue I was having: to search all public functions for a list of terms. Sample usage is below