Hi, On Wed, Aug 15, 2012 at 1:02 AM, Little, Douglas <DOUGLAS.LITTLE@xxxxxxxxxx> wrote: > Can someone let me know the correct way to do this? > > This is failing > where p.oid = cast(proname as regproc); > > NOTICE: found dba_work.pg_get_functiondef2 > WARNING: sqlstate 42846 > WARNING: sqlerrm cannot cast type text to regproc > > CREATE OR REPLACE FUNCTION dba_work.pg_get_functiondef2(proname text) > ... > where p.oid = cast(proname as name); > ... Typo? -- Sergey Konoplev a database architect, software developer at PostgreSQL-Consulting.com http://www.postgresql-consulting.com Jabber: gray.ru@xxxxxxxxx Skype: gray-hemp Phone: +79160686204 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
