Re: BUG #6670: Translate small SQL from 8.0 ti 7.3 - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #6670: Translate small SQL from 8.0 ti 7.3
Date
Msg-id CA+TgmobN1DJzLn0_XjbbR1_GSMrN_go2CZ8DDeRieayMLcad8Q@mail.gmail.com
Whole thread Raw
In response to BUG #6670: Translate small SQL from 8.0 ti 7.3  (ByGlow@mail.ua)
List pgsql-bugs
On Thu, May 31, 2012 at 3:34 AM,  <ByGlow@mail.ua> wrote:
> The following bug has been logged on the website:
>
> Bug reference: =A0 =A0 =A06670
> Logged by: =A0 =A0 =A0 =A0 =A0Roman
> Email address: =A0 =A0 =A0ByGlow@mail.ua
> PostgreSQL version: Unsupported/Unknown
> Operating system: =A0 Win32
> Description:
>
> Bruce, tell me PLEASE how make this in 7.3:
>
>
> SELECT t.oid, format_type(t.oid, -1) AS basetype
> =A0FROM pg_proc p
> =A0 =A0INNER JOIN pg_type t
> =A0 =A0 =A0ON t.oid =3D p.prorettype OR t.oid =3D ANY (p.proargtypes) OR =
t.oid =3D 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.

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

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6659: Error when install postgres
Next
From: Dave Page
Date:
Subject: Re: 9.2 beta1 libxml2 can't be loaded on Windows