agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Niranjan Perera <perera@pollux.cs.uga.edu>
To: postgres@postgres.Berkeley.EDU
Subject: 4.1 specific qestion.
Date: Fri, 27 May 1994 17:26:52 -0400 (EDT)
Message-ID: <9405272126.AA16689@pollux.cs.uga.edu> (raw)


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.
==============================================================================

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: perera@pollux.cs.uga.edu
  Subject: Re: 4.1 specific qestion.
  In-Reply-To: <9405272126.AA16689@pollux.cs.uga.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox