Re: cast name to oid

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

In response to

Browse pgsql-general by date

  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