Обсуждение: Practical SQL Handbook

Поиск
Список
Период
Сортировка

Practical SQL Handbook

От
Rasputin
Дата:
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

От
Rasputin
Дата:
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