From jkanter@virginia.edu Tue May 27 14:20:38 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 5EBF4924D65 for ; Tue, 27 May 2003 10:20:38 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 80524-06 for ; Tue, 27 May 2003 10:20:36 -0400 (EDT) Received: from mail.virginia.edu (mail.Virginia.EDU [128.143.2.9]) by developer.postgresql.org (Postfix) with SMTP id 6FEC8924D5F for ; Tue, 27 May 2003 10:20:36 -0400 (EDT) Received: from smtp.mail.virginia.edu by mail.virginia.edu id aa19623; 27 May 2003 10:20 EDT Received: from virginia.edu (d-128-19-222.bootp.Virginia.EDU [128.143.19.222]) by smtp.mail.Virginia.EDU (8.11.7/8.11.6) with ESMTP id h4REKXl23562 for ; Tue, 27 May 2003 10:20:34 -0400 Message-ID: <3ED375FF.5090502@virginia.edu> Date: Tue, 27 May 2003 10:28:15 -0400 From: Jodi Kanter User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1 X-Accept-Language: en-us MIME-Version: 1.0 To: Postgres SQL List Subject: [Fwd: SQL book] Content-Type: multipart/alternative; boundary="------------070504010501050906090909" X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/507 X-Sequence-Number: 13672 --------------070504010501050906090909 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit I am looking to purchase a SQL book to use with our postgresql database. Can anyone recommend a good one? Thanks Jodi -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu -- _______________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (434) 924-2846 jkanter@virginia.edu --------------070504010501050906090909 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit I am looking to purchase a SQL book to use with our postgresql database. Can anyone recommend a good one?
Thanks
Jodi
--
________________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

 

 

--
________________________________

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu

 

 

 

--------------070504010501050906090909-- From tomg@sqlclinic.net Tue May 27 15:02:04 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 6F3A8924E67 for ; Tue, 27 May 2003 11:02:04 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 92602-10 for ; Tue, 27 May 2003 11:01:51 -0400 (EDT) Received: from mail1.panix.com (mail1.panix.com [166.84.1.72]) by developer.postgresql.org (Postfix) with ESMTP id 03568924E57 for ; Tue, 27 May 2003 11:01:51 -0400 (EDT) Received: from mailhost.nrnet.org (mailhost.nrnet.org [166.84.192.39]) by mail1.panix.com (Postfix) with ESMTP id B3A9D48703; Tue, 27 May 2003 11:01:48 -0400 (EDT) Received: from sqlclinic.net (uucp@localhost) by mailhost.nrnet.org (8.11.4/8.11.4) with UUCP id h4REhZd00599; Tue, 27 May 2003 10:43:35 -0400 Received: from q8.nrnet.org (IDENT:1000@localhost [127.0.0.1]) by q8.nrnet.org (8.12.4/8.12.4) with ESMTP id h4RF6DK3029450; Tue, 27 May 2003 11:06:13 -0400 Received: from localhost (tomg@localhost) by q8.nrnet.org (8.12.4/8.12.4/Submit) with ESMTP id h4RF6DQT029447; Tue, 27 May 2003 11:06:13 -0400 X-Authentication-Warning: q8.nrnet.org: tomg owned process doing -bs Date: Tue, 27 May 2003 11:06:12 -0400 (EDT) From: Thomas Good X-X-Sender: tomg@q8.nrnet.org To: Jodi Kanter Cc: Postgres SQL List Subject: Re: [Fwd: SQL book] In-Reply-To: <3ED375FF.5090502@virginia.edu> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/512 X-Sequence-Number: 13677 On Tue, 27 May 2003, Jodi Kanter wrote: > I am looking to purchase a SQL book to use with our postgresql database. > Can anyone recommend a good one? > Thanks > Jodi Hi Jodi, I use SQL In A Nutshell as I have to switch gears between Oracle, Postgres and MySQL. Also I have limited time for reading and am a very cheap guy. It goes for $30 US. RE: perl. Paul DuBois has a great book called MySQL and Perl for the Web. Just modify the queries for Pg and you have a terrific example of how to code via DBI. Besides which it goes for $20 US on Amazon (orig $45 US). If you like I can mail you the tarball of Paul's src. I have it here at work. Paul also has a downloadable archive of all the scripts in the book. Lastly, he is a member of the Perl DBI mailing list which is a valuable resource as Tim Bunce reads all the mail that goes by and occasionally jumps in. (He wrote both DBI and DBD-Oracle). Cheers ----------------------------------------------------------------------- Thomas Good e-mail: tomg@sqlclinic.net Programmer/Analyst phone: (+1) 718.818.5528 Residential Services fax: (+1) 718.818.5056 Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359 // Das ist die Kunst - wie man alles verhunzt. From josh@agliodbs.com Tue May 27 15:55:23 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 3AE82924E37 for ; Tue, 27 May 2003 11:55:23 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 11100-07 for ; Tue, 27 May 2003 11:55:21 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id 3DB9A924E30 for ; Tue, 27 May 2003 11:55:21 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3070993; Tue, 27 May 2003 08:55:19 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Jodi Kanter , Postgres SQL List Subject: Re: [Fwd: SQL book] Date: Tue, 27 May 2003 08:53:13 -0700 User-Agent: KMail/1.4.3 References: <3ED375FF.5090502@virginia.edu> In-Reply-To: <3ED375FF.5090502@virginia.edu> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305270853.13802.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/516 X-Sequence-Number: 13681 Jodi, > I am looking to purchase a SQL book to use with our postgresql database. > Can anyone recommend a good one? See: http://techdocs.postgresql.org/techdocs/bookreviews.php (HEY EVERYONE ELSE: I could use some more book reviews. It's 100 words, it's not hard ... e-mail me!) -- Josh Berkus Aglio Database Solutions San Francisco From josh@agliodbs.com Tue May 27 16:08:50 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 3DC5F924E75 for ; Tue, 27 May 2003 12:08:50 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 15766-02 for ; Tue, 27 May 2003 12:08:48 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id 68F6C924E57 for ; Tue, 27 May 2003 12:08:48 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3071049; Tue, 27 May 2003 09:08:52 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Thomas Good , Jodi Kanter Subject: Re: [Fwd: SQL book] Date: Tue, 27 May 2003 09:06:46 -0700 User-Agent: KMail/1.4.3 Cc: Postgres SQL List References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305270906.46753.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/517 X-Sequence-Number: 13682 Thomas, > I use SQL In A Nutshell as I have to switch gears between Oracle, Postgres > and MySQL. Also I have limited time for reading and am a very cheap guy. > It goes for $30 US. FYI, as I mention in my review, I found that SQL in a Nutshell omits several important SQL commands. But it does give you a good general syntax comparison. Jodi, SQL in a Nutshell is a reference for people who already know SQL ... not a primer. -- Josh Berkus Aglio Database Solutions San Francisco From ries@jongert.nl Wed May 28 06:54:40 2003 X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 97725924D37 for ; Wed, 28 May 2003 02:54:40 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 27591-05 for ; Wed, 28 May 2003 02:54:39 -0400 (EDT) Received: from jongert.nl (jongert.nl [194.109.59.87]) by developer.postgresql.org (Postfix) with ESMTP id 4CB17924D07 for ; Wed, 28 May 2003 02:54:37 -0400 (EDT) Received: from IT001 (IT001.int.jongert.nl [10.0.0.241]) by jongert.nl (Postfix) with SMTP id 73F6917D; Wed, 28 May 2003 08:54:19 +0200 (CEST) From: "Ries van Twisk" To: "'Jodi Kanter'" , "'Postgres SQL List'" Subject: Re: [Fwd: SQL book] Date: Wed, 28 May 2003 08:54:17 +0200 Message-ID: <003901c324e5$f5a68eb0$f100000a@IT001> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 In-Reply-To: <3ED375FF.5090502@virginia.edu> Importance: Normal X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/533 X-Sequence-Number: 13698 Jodi, get some of Joe Celco books for me they where extreemly usefull. Ries