Re: [GENERAL] Search for text in any function

2009-02-19 Thread hubert depesz lubaczewski
On Thu, Feb 19, 2009 at 01:27:23PM -0500, Rob Richardson wrote: > Thank you very much. It works, as I'm sure you knew. > > But I have a further question. I've never seen the "~*" operator > before, and searching for it in the docs and on Google did not return > any results I could find. What do

Re: [GENERAL] Search for text in any function

2009-02-19 Thread Rob Richardson
Thank you very much. It works, as I'm sure you knew. But I have a further question. I've never seen the "~*" operator before, and searching for it in the docs and on Google did not return any results I could find. What does it mean? Thanks again! RobR -- Sent via pgsql-general mailing list

Re: [GENERAL] Search for text in any function

2009-02-19 Thread hubert depesz lubaczewski
On Thu, Feb 19, 2009 at 12:46:41PM -0500, Rob Richardson wrote: > Can anyone suggest a query that will tell me the names of all functions > (both trigger and normal) that contain a given string of text? assuming you mean pl/* functions, you can simply use: select proname from pg_proc where prosrc