Return-Path: owner-postman 
Delivery-Date: Thu, 28 Apr 94 22:54:27 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id TAA08695 for postgres-redist; Thu, 28 Apr 1994 19:56:11 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199404290256.TAA08695@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from pollux.cs.uga.edu (pollux.cs.uga.edu [128.192.4.5]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id TAA08685 for <postgres@postgres.berkeley.edu>; Thu, 28 Apr 1994 19:56:10 -0700
From: perera@pollux.cs.uga.edu
Received: by pollux.cs.uga.edu (4.1/25-eef)
	id AA06776; Thu, 28 Apr 94 22:56:07 EDT
Date: Thu, 28 Apr 94 22:56:07 EDT
Message-Id: <9404290256.AA06776@pollux.cs.uga.edu>
To: postgres@postgres.Berkeley.EDU
Subject: attribute question
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Thu, 28 Apr 94 19:56:11 -0700
Resent-XMts: smtp

Hi:

How does one get all attributes except one from a table ?

I tried the following...

retrieve into temp ( s.all )
where pg_class.relname = "s" and  pg_attribute.attname !~ "sno" \g

which did not work...

-- Niranjan


===============================================================================
    To add/remove yourself 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.
===============================================================================