Thread: Book and TEMP vs. TEMPORARY

Book and TEMP vs. TEMPORARY

From
Bruce Momjian
Date:
I am doing the chapter on temporary tables.  Should I show examples
using TEMP or TEMPORARY?

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Book and TEMP vs. TEMPORARY

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I am doing the chapter on temporary tables.  Should I show examples
> using TEMP or TEMPORARY?

TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...
        regards, tom lane


Re: Book and TEMP vs. TEMPORARY

From
Bruce Momjian
Date:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I am doing the chapter on temporary tables.  Should I show examples
> > using TEMP or TEMPORARY?
> 
> TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...

OK, but TEMPORARY doesn't work on 6.5.*, right?

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Book and TEMP vs. TEMPORARY

From
Bruce Momjian
Date:
> On Thu, Apr 06, 2000 at 11:38:10AM -0400, Bruce Momjian wrote:
> > > Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > > > I am doing the chapter on temporary tables.  Should I show examples
> > > > using TEMP or TEMPORARY?
> > > 
> > > TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...
> > 
> > OK, but TEMPORARY doesn't work on 6.5.*, right?
> 
> Seems to work in 6.5.0, here:

Oh, that's great news.  I though it was only added in 7.0.  I now see it
in 6.5.3.  I think in 7.0 we just allowed TEMP as a user column.

For the book, TEMPORARY it is.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Book and TEMP vs. TEMPORARY

From
Thomas Lockhart
Date:
> > TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...
> OK, but TEMPORARY doesn't work on 6.5.*, right?

Sure it does (at least as far as I can tell. The test/locale stuff has
screwed up CVS update, so I have to do a clean checkout of at least
that directory to get my tree back in shape :(

And, to beat a dead horse, I'm *still* not sure why we are carrying
along the "TEMP" variant, losing the use of that name for other
things.
                    - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


Re: Book and TEMP vs. TEMPORARY

From
Bruce Momjian
Date:
> > > TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...
> > OK, but TEMPORARY doesn't work on 6.5.*, right?
> 
> Sure it does (at least as far as I can tell. The test/locale stuff has
> screwed up CVS update, so I have to do a clean checkout of at least
> that directory to get my tree back in shape :(
> 
> And, to beat a dead horse, I'm *still* not sure why we are carrying
> along the "TEMP" variant, losing the use of that name for other
> things.

Well, Tom Lane made it so we allow TEMP as an indentifier.  I now
remember that the issue with 7.0 was that everyone beat up on me because
I used TEMP instead of the SQL92-standard TEMPORARY when implementing
temporary tables.  See, it works now:
test=> create table x ( temp char(2));CREATE

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Book and TEMP vs. TEMPORARY

From
Don Baccus
Date:
At 11:38 AM 4/6/00 -0400, Bruce Momjian wrote:
>> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> > I am doing the chapter on temporary tables.  Should I show examples
>> > using TEMP or TEMPORARY?
>> 
>> TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...
>
>OK, but TEMPORARY doesn't work on 6.5.*, right?

Won't 7.0 be the release version by the time the book is actually
published? :)



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


Re: Book and TEMP vs. TEMPORARY

From
Bruce Momjian
Date:
> At 11:38 AM 4/6/00 -0400, Bruce Momjian wrote:
> >> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> > I am doing the chapter on temporary tables.  Should I show examples
> >> > using TEMP or TEMPORARY?
> >> 
> >> TEMPORARY is SQL92 standard, TEMP is not.  Nuff said...
> >
> >OK, but TEMPORARY doesn't work on 6.5.*, right?
> 
> Won't 7.0 be the release version by the time the book is actually
> published? :)

Yes.  I was just getting confirmation before putting in a 7.0-specific
thing.  However, TEMPORARY is supported in 6.5.*, so I am in good shape
with TEMPORARY.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


Re: Book and TEMP vs. TEMPORARY

From
Don Baccus
Date:
At 01:54 PM 4/6/00 -0400, Bruce Momjian wrote:

>> Won't 7.0 be the release version by the time the book is actually
>> published? :)
>
>Yes.  I was just getting confirmation before putting in a 7.0-specific
>thing.  However, TEMPORARY is supported in 6.5.*, so I am in good shape
>with TEMPORARY.

Note the smiley, I was just teasing.

What is the current ETA on 7.0's official release, anyway?



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert
Serviceand other goodies at http://donb.photo.net.
 


Re: Book and TEMP vs. TEMPORARY

From
Bruce Momjian
Date:
> At 01:54 PM 4/6/00 -0400, Bruce Momjian wrote:
> 
> >> Won't 7.0 be the release version by the time the book is actually
> >> published? :)
> >
> >Yes.  I was just getting confirmation before putting in a 7.0-specific
> >thing.  However, TEMPORARY is supported in 6.5.*, so I am in good shape
> >with TEMPORARY.
> 
> Note the smiley, I was just teasing.
> 
> What is the current ETA on 7.0's official release, anyway?
> 

Mid to end of April.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026