Thread: Practical SQL Handbook

Practical SQL Handbook

From
Rasputin
Date:
Is there a set of scripts to create the 'bookbiz' database
from this book for Postgres? Or could someone recommend which one on the CD
requires the least changes?

I'm on chapter 2, sove gentle :)

--
Lazlo's Chinese Relativity Axiom:
    No matter how great your triumphs or how tragic your defeats --
approximately one billion Chinese couldn't care less.
Rasputin :: Jack of All Trades - Master of Nuns

Re: Practical SQL Handbook

From
Rasputin
Date:
I found it - used the one that  Mark Biggers mentioned in:

http://www.wnclug.org/lists/wnclug/2001/msg00206.html

It needed a few tweaks to install to 7.3.3:
as the money type was deprecated, I replaced it with numeric(9,2)
and cdropped the '$' from selects in some of the views.

If anyone wants it, it's at:

http://idoru.mine.nu/sql/bookbiz.pgres.sql

Cheers.

--
Cynic, n.:
    One who looks through rose-colored glasses with a jaundiced eye.
Rasputin :: Jack of All Trades - Master of Nuns