From: | Sergey Konoplev <sergey(dot)konoplev(at)postgresql-consulting(dot)com> |
---|---|
To: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
Cc: | "PostgreSQL General (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: cast name to oid |
Date: | 2012-08-15 06:29:40 |
Message-ID: | CAL_0b1ttZqUsJ8=jVHCVSEfr9FMaKC1RNnPNHqnJcXqsmKGADQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
On Wed, Aug 15, 2012 at 1:02 AM, Little, Douglas
<DOUGLAS(dot)LITTLE(at)orbitz(dot)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(dot)ru(at)gmail(dot)com Skype: gray-hemp Phone: +79160686204
From | Date | Subject | |
---|---|---|---|
Next Message | Carl von Clausewitz | 2012-08-15 07:57:25 | corrupted statistics file "pg_stat_tmp/pgstat.stat" |
Previous Message | Peter Eisentraut | 2012-08-15 04:58:14 | Re: Regarding pc-lint on PostgreSQL code |