Re: [ADMIN] Location of a new column

2004-04-12 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > On Thu, 2004-04-08 at 09:55, Stephan Szabo wrote: >> AFAIK, you can't using add column. It currently does no more than the >> SQL92/99 spec requires in that respect (which is put the column at the >> end). > IIRC this option is available in 7.5. No, ther

Re: [ADMIN] Location of a new column

2004-04-12 Thread Robert Treat
On Thu, 2004-04-08 at 09:55, Stephan Szabo wrote: > > On Thu, 8 Apr 2004, Terry Hampton wrote: > > > I thought this was answered before, but I > > could not find anything in my saved email. > > > > I need to ALTER a table to add a new column. > > I want the new column to be betwee

Re: [Fwd: Re: [ADMIN] Location of a new column]

2004-04-08 Thread Geoffrey
scott.marlowe wrote: I replied, and finally got him unsubscribed from the list. He was just tired of receiving our admin list all the time and couldn't figure out how to turn it off, so I walked him through the web interface to get off the list. So he chose such an appropriate solution since he wa

Re: [Fwd: Re: [ADMIN] Location of a new column]

2004-04-08 Thread scott.marlowe
e know this list member, > who was kind enought to reply? > > > > Original Message ---- > Subject: Re: [ADMIN] Location of a new column > Date: Thu, 8 Apr 2004 06:58:56 -0700 > From: "scott" <[EMAIL PROTECTED]> > To: "Terry H

Re: [Fwd: Re: [ADMIN] Location of a new column]

2004-04-08 Thread Stephan Szabo
> Subject: Re: [ADMIN] Location of a new column > Date: Thu, 8 Apr 2004 06:58:56 -0700 > From: "scott" <[EMAIL PROTECTED]> > To: "Terry Hampton" <[EMAIL PROTECTED]> > References: <[EMAIL PROTECTED]> > > FUCK U > - Original Messa

[Fwd: Re: [ADMIN] Location of a new column]

2004-04-08 Thread Terry Hampton
Anyone know this list member, who was kind enought to reply? Original Message Subject: Re: [ADMIN] Location of a new column Date: Thu, 8 Apr 2004 06:58:56 -0700 From: "scott" <[EMAIL PROTECTED]> To: "Terry Hampton" <[EMAIL PROTECTED]&g

Re: [ADMIN] Location of a new column

2004-04-08 Thread Stephan Szabo
On Thu, 8 Apr 2004, Terry Hampton wrote: > I thought this was answered before, but I > could not find anything in my saved email. > > I need to ALTER a table to add a new column. > I want the new column to be between two existing > columns, however. Didn't I see

[ADMIN] Location of a new column

2004-04-08 Thread Terry Hampton
All, I thought this was answered before, but I could not find anything in my saved email. I need to ALTER a table to add a new column. I want the new column to be between two existing columns, however. Didn't I see mention of an "AFTER" paramet