Book and TEMP vs. TEMPORARY
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
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
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 19026On 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, Pennsylvania 19026Import Notes
Reply to msg id not found: 20000406111512.E9307@rice.edu | Resolved by subject fallback
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 19026Import Notes
Reply to msg id not found: 38ECBF33.8E12BF00@alumni.caltech.edu | Resolved by subject fallback
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
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.
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 19026At 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.
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