Thread: Practical SQL Handbook
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
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