Delivery-Date: Sun, 15 May 94 21:53:44 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405160236.TAA05879@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: Niranjan Perera <perera@pollux.cs.uga.edu>
Message-Id: <9405160236.AA04523@pollux.cs.uga.edu>
Subject: A better way ?
To: postgres@postgres.Berkeley.EDU
Date: Sun, 15 May 1994 22:36:45 -0400 (EDT)
Content-Type: text
Content-Length: 719       
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Sun, 15 May 94 19:36:49 -0700
Resent-XMts: smtp

Hi:

I have a class that keeps a list of classes. What I would like to know
is there an efficent way for me to find out if any new classes  have been
created since I last accessed the database, by comparing against my class ?

I currently use..

retrieve ( pg_class.relname )
where pg_class.relname !~ "pg_" and pg_class.relname !~ "myclass"


store the results and then run each result against "myclass"

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