Re: about pg_proc (column pronamespace)

From: Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: about pg_proc (column pronamespace)
Date: 2009-09-11 18:14:17
Message-ID: 4AAA9379.40403@fmed.uba.ar
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane wrote:
> Gerardo Herzig <gherzig(at)fmed(dot)uba(dot)ar> writes:
>> Obviously im missing something, i cant find any relation between
>> pg_proc.pronamespace and pg_namespace.
>
> You didn't look at pg_namespace.oid, which is a "system column"
> meaning SELECT * doesn't show it.
>
> regards, tom lane
>
>
Oh, yeah. A little surprised, but yes there it is!
Thanks Tom.

Gerardo

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gerardo Herzig 2009-09-11 20:16:30 its posible to use a 2 column returning function as a subquery?
Previous Message Tom Lane 2009-09-11 18:12:50 Re: about pg_proc (column pronamespace)