Re: BUG #6670: Translate small SQL from 8.0 ti 7.3

On Thu, May 31, 2012 at 3:34 AM, <ByGlow(at)mail(dot)ua> wrote:
> The following bug has been logged on the website:
>
> Bug reference:      6670
> Logged by:          Roman
> Email address:      ByGlow(at)mail(dot)ua
> PostgreSQL version: Unsupported/Unknown
> Operating system:   Win32
> Description:
>
> Bruce, tell me PLEASE how make this in 7.3:
>
>
> SELECT t.oid, format_type(t.oid, -1) AS basetype
>  FROM pg_proc p
>    INNER JOIN pg_type t
>      ON t.oid = p.prorettype OR t.oid = ANY (p.proargtypes) OR t.oid = ANY
> (p.proallargtypes)
>
>
> ANY and oidvector (int2vector)!
>
> it's possible ?

This is not a bug, and 7.3 is not supported (nor is 8.0). But you
could try asking on pgsql-general.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company