Received: from C654771-a.frmt1.sfba.home.com (IDENT:root@c654771-a.frmt1.sfba.home.com [24.1.65.243]) by hub.org (8.10.1/8.10.1) with ESMTP id e6I2bZ087204 for ; Mon, 17 Jul 2000 22:37:36 -0400 (EDT) Received: (from kumar1@localhost) by C654771-a.frmt1.sfba.home.com (8.9.3/8.9.3) id TAA22398; Mon, 17 Jul 2000 19:37:35 -0700 To: pgsql-sql@postgresql.org Subject: Re: Select by priority References: From: kumar1@home.com (Prasanth A. Kumar) Date: 17 Jul 2000 19:37:35 -0700 In-Reply-To: "Gary J. Farmer"'s message of "Mon, 17 Jul 2000 17:12:54 -0500" Message-ID: Lines: 23 X-Mailer: Gnus v5.7/Emacs 20.7 X-Archive-Number: 200007/172 "Gary J. Farmer" writes: > >> I think the order thing will work though I have no choice of using > >> numbering for the address_type as I am working off a pre-existing > >> database. They are using a mnemonic char type. I am essentially batch > >> downloading and processing this and other database tables for query > >> and presentations using web pages. BTW, does the 'limit' feature exist > >> in Oracle? The main database I am extracting data from is Oracle... > > I do not know whether you can add a table associating "priority" with > "address_type". If you can, you might try something like the following > example, using the address_priority table: > Appears to work with either Oracle or Postgres (though I changed VARCHAR > to VARCHAR2 for Oracle). > > Gary Farmer That looks like a workable solution. I'll try it out. Thanks... -- Prasanth Kumar kumar1@home.com