From: Bruce Momjian <pgman@candle.pha.pa.us>
To: kaiq@realtyideas.com
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] the book and sql92
Date: Fri, 3 Dec 1999 02:56:27 -0500 (EST)
Message-ID: <199912030756.CAA07450@candle.pha.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.10.9912030013350.4044-100000@picasso.realtyideas.com>
> I finished the book (version Nov 30). It is a very good one. clear and
> straight to the point.
> some comments:
> A)
> here are my 2-cents:
> 1)I found a type in p55 line 4552: "than" should be "that".
Fixed. Thanks.
> 2) when I read it, I feel the data in the example should be given.
> i.e., all the inserts should be given (esp. on p58).
Well, the issue here is that I really have not developed enough data to
show a meaningful output for this, and I don't think it is worth the
major space needed to insert it. That is why I left it out.
> B)
> here is a big question: why you say that normalization is good for
> data retreval (page 43 )? If my memory not wrong, it is ONLY good for data
> update/insert/delete.
Changed to 'data lookup' because without normalization, you can't lookup
information about a specific customer very easily.
>
> C) here is the main concern: sql92.
> 1) page3, after talk oss, the book should mention sql92;
> and treat the whole book accordingly (see next).
I disagree. This is an intro/concepts. I emphasize standard SQL ways
as much as possible. Yesterday I changed now() to CURRENT_TIMESTAMP for
this reason, and if you see any other cases where I use non-standard
more, let me know. However, this is just to get them started. They
want results. Worrying about standard SQL at this point is not a good
idea. Get them started first. I emphasize that, but don't want to be
pointing out saying "don't do this, and don't do that" at this point.
> 2) page10, \g should not be used as recommened one. ; should be used.
> this is not sql92 (?), but ";" is certainly the most used.
\g used very rarely, but it should be shown to show consistency with
other psql commands.
> 3) page19: single quotation mark should be mentioned as the prefered
> one. (sql92 ).
single mentioned first.
> 4) page23: /* */ should be mentioned that it is not sql92.
Mentioned last.
> 5) page27: != is not sql92.
Many db's support this.
> 6) page28: regex is not sql92, so, should be considered ONLY
> after tried like ;
Again, see above.
> 7) page31: in "case", should indicate that "end" is not needed in sql92,
> and thus very likely later version of pg may also not need end.
No need.
> 8) page61: oid should be used in caution, because, in short, it is not in
> sql92.
>
> in short, all non-necessary non-sql92 features should be put into
> secondary position. all important feature that is not sql92 should
> be pointed out.
>
> we OSS/PG people should differentiate/advertize ourselves as
> standard-keeper. so, this book should keep this as the main topic.
> It will NOT confuse new user/beginner, if handled consistantly.
> Also, it will add the worth-value for old pg user for sql92 info.
>
>
> hope this book will not like all other vendor-oriented books where
> as if sql86/92 never exists! sql86/92 are our friends, even family member!
That is not the scope of this book.
--
Bruce Momjian | http://www.op.net/~candle
maillist@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: pgman@candle.pha.pa.us, kaiq@realtyideas.com
Subject: Re: [SQL] the book and sql92
In-Reply-To: <199912030756.CAA07450@candle.pha.pa.us>
References: <Pine.LNX.4.10.9912030013350.4044-100000@picasso.realtyideas.com> <199912030756.CAA07450@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox