Skip site navigation (1) Skip section navigation (2)

Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: Bruce Stephens <bruce(at)cenderis(dot)demon(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL
Date: 1998-04-25 17:49:55
Message-ID: Pine.BSF.3.96.980425144900.298Q-100000@thelab.hub.org (view raw or flat)
Thread:
Lists: pgsql-hackers
Moved to pgsql-hackers(at)postgresql(dot)org (where the developers hang out)

On 24 Apr 1998, Bruce Stephens wrote:

> -----
> The NULL contraint: PostgreSQL only allows NOT NULL (NULL being the
> default).  I altered the backend grammar for this one.

	Patch?

> Floating point literals: PostgreSQL requires that positive floating
> point constants start with a digit, but the script has ".10" and
> things.  Same here, I altered the lexical spec for floats, but it's
> possible there was a reason for it being the way it was.

	Patch?

> View syntax: The script has "CREATE VIEW foo (a, b, c) AS SELECT ..."
> which doesn't seem to be acceptable to PostgreSQL.  I rephrased these
> as "CREATE VIEW foo AS SELECT blah AS a, ..." and so on.
> 
> Commands separated by "go", not ";".  Don't know whether this would be
> easy or hard to do, or whether it's important.  Global substitution
> for this.
> 
> Some types, like "tinyint" aren't available, so I just substituted
> "int".
> 
> Some of the views are only creatable as the PostgreSQL superuser.
> (This is on the TODO list, I think.)
> -----
> 
> I think that was it.  Presumably the developers will be making some
> effort to get this to work (at least most of it: "go" vs ";" is a bit
> irrelevant, but NULL is important, IMHO); it's surely slightly
> embarrassing to recommend a book which has an example that won't run!
> --
> Official WWW Site: http://www.postgresql.org
> Online Docs & FAQ: http://www.postgresql.org/docs
> Searchable Lists: http://www.postgresql.org/mhonarc
> 

Marc G. Fournier                                
Systems Administrator @ hub.org 
primary: scrappy(at)hub(dot)org           secondary: scrappy(at){freebsd|postgresql}.org 


Responses

pgsql-hackers by date

Next:From: Bruce StephensDate: 1998-04-25 18:43:01
Subject: Re: [QUESTIONS] Practical SQL Handbook - demo script for postgreSQL
Previous:From: Tom LaneDate: 1998-04-25 16:46:41
Subject: Re: [HACKERS] Re: [PHP3] BIG, BIG problems with pg_pConnect in PHP3, PostgreSQL and Apache httpd

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group