Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0A6709FA473 for ; Tue, 3 Oct 2006 08:56:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 07658-09 for ; Tue, 3 Oct 2006 08:56:13 -0300 (ADT) X-Greylist: delayed 00:05:01.233066 by SQLgrey- Received: from rwcrmhc13.comcast.net (rwcrmhc13.comcast.net [216.148.227.153]) by postgresql.org (Postfix) with ESMTP id 17D759FA3D7 for ; Tue, 3 Oct 2006 08:56:13 -0300 (ADT) Received: from [70.194.182.135] (135.sub-70-194-182.myvzw.com[70.194.182.135]) by comcast.net (rwcrmhc13) with SMTP id <20061003114944m1300lebose>; Tue, 3 Oct 2006 11:49:45 +0000 User-Agent: Microsoft-Entourage/11.2.5.060620 Date: Tue, 03 Oct 2006 07:49:37 -0400 Subject: Re: i have table From: Daryl Richter To: "Penchalaiah P." , Message-ID: Thread-Topic: [SQL] i have table Thread-Index: Acbm2VLoWdlRvbJGTCKPqfoSAA5FBwACK15O In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200610/17 X-Sequence-Number: 26406 On 10/3/06 6:47 AM, "Penchalaiah P." wrote: >=20 > Hi ... >=20 > I have one table with 12 fields.. >=20 >=20 > now I want to add one more field in this table.. but that field has to > come next to cda_no.. I mean as a 3rd field.. If I am adding that field > it is coming last field ... > The columns in a relation (table) are not ordered, so this question makes n= o sense. Why do you feel it necessary to have that field "next to" the other= ? =20 >=20 > may I know how it is possible to that table... >=20 > Thanks & Regards >=20 > Penchal reddy | Software Engineer >=20 -- Daryl http://itsallsemantics.com "I=B9m afraid of the easy stuff=8A its always harder than it seems=8A" -- Bill Hampton, 2006