Received: from lee.k12.nc.us (mail.lee.k12.nc.us [207.4.71.118]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA03533 for ; Tue, 4 Aug 1998 08:23:33 -0400 (EDT) Received: by gateway.lee.k12.nc.us id <35713>; Mon, 3 Aug 1981 07:15:31 -0400 Date: Tue, 4 Aug 1998 08:26:16 -0400 From: James Olin Oden X-Mailer: Mozilla 4.04 [en] (Win95; I) MIME-Version: 1.0 To: "D'Arcy J.M. Cain" CC: pgsql-sql@postgreSQL.org Subject: Re: [SQL] can a column be aliased? References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <81Aug3.071531edt.35713@gateway.lee.k12.nc.us> > I don't think so. Better use a sequence instead. You shouldn't be > using OID as a key anyway. You lose the value if you dump and reload. > Ah...there's the rub. Well, I haven't been doing that anyway; I was merely trying to explore the possiblity of doing so after I heard some users ask about it. At first thought I had the reservation of it not being portable, but with your thought (they change after a dump and reload) I can see that's a _real_ bad idea. Thanks...james > -- > D'Arcy J.M. Cain | Democracy is three wolves > http://www.druid.net/darcy/ | and a sheep voting on > +1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.