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, Pennsylvania 19026

Thu, 6 Apr 2000 11:12:45 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Book and TEMP vs. TEMPORARY
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

Thu, 06 Apr 2000 11:31:40 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Book and TEMP vs. TEMPORARY 
> 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, Pennsylvania 19026

Thu, 6 Apr 2000 11:38:10 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Book and TEMP vs. TEMPORARY
> > > 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, Pennsylvania 19026

Thu, 6 Apr 2000 12:41:40 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Book and TEMP vs. TEMPORARY
> > 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

Thu, 06 Apr 2000 16:45:39 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: Book and TEMP vs. TEMPORARY
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 Service and other goodies at
  http://donb.photo.net.

Thu, 06 Apr 2000 10:11:54 -0700
Don Baccus <dhogaza@pacifier.com>
Re: Book and TEMP vs. TEMPORARY
> 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, Pennsylvania 19026

Thu, 6 Apr 2000 13:54:11 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Book and TEMP vs. TEMPORARY
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 Service and other goodies at
  http://donb.photo.net.

Thu, 06 Apr 2000 11:34:05 -0700
Don Baccus <dhogaza@pacifier.com>
Re: Book and TEMP vs. TEMPORARY
> 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, Pennsylvania 19026

Thu, 6 Apr 2000 14:57:33 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Book and TEMP vs. TEMPORARY