Hi,
On Wed, Aug 15, 2012 at 1:02 AM, Little, Douglas
<DOUGLAS.LITTLE@orbitz.com> 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@gmail.com Skype: gray-hemp Phone: +79160686204
