Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405272126.OAA25813@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: Niranjan Perera <perera@pollux.cs.uga.edu>
Message-Id: <9405272126.AA16689@pollux.cs.uga.edu>
Subject: 4.1 specific qestion.
To: postgres@postgres.Berkeley.EDU
Date: Fri, 27 May 1994 17:26:52 -0400 (EDT)
Content-Type: text
Content-Length: 667       
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Fri, 27 May 94 14:26:58 -0700
Resent-XMts: smtp


Hi:

Could some kind soul run the following query on POSTGRES version 4.1
and let me know what they get back. i.e do you get a, b, c ?

create A ( a = int4, b = int4, c = int4 )

retrieve ( a.attname )
from a in pg_attribute, c in pg_class
  where c.relname = "A"
  and c.relkind = 'r'
  and a.attrelid = c.oid 
  and a.attnum > 0

destroy A

Thanks,

-- Niranjan


-- 
+----------------------------------------------------------------?------+
| Niranjan Perera, 415 GSRC Bldg,CS Dept,  perera@cs.uga.edu    ~~~     |
| University Of Georgia, Athens GA30602.   (706)-548-5826     ( . . )   |
+-----------------------------------------------------------ooO-(_)-Ooo-+

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================