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: (view raw, whole thread or download thread mbox)
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.


> 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.


> 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:
> Online Docs & FAQ:
> Searchable Lists:

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


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-2017 The PostgreSQL Global Development Group