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

2012-06-08 Thread Robert Haas
On Thu, May 31, 2012 at 3:34 AM,  byg...@mail.ua wrote:
 The following bug has been logged on the website:

 Bug reference:      6670
 Logged by:          Roman
 Email address:      byg...@mail.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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


[BUGS] BUG #6670: Translate small SQL from 8.0 ti 7.3

2012-05-31 Thread ByGlow
The following bug has been logged on the website:

Bug reference:  6670
Logged by:  Roman
Email address:  byg...@mail.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 ?


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs