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

Re: First decent PostgreSQL CBT now on

From: Joe Conway <joseph(dot)conway(at)home(dot)com>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: First decent PostgreSQL CBT now on
Date: 2001-12-28 06:45:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announcepgsql-general
Justin Clift wrote:

> For the last month and a half or so I've pretty much devoted all my
> spare time to creating the first of a series of Macromedia Flash Player
> based tutorials on aspects of PostgreSQL.  I'm working to get a decent
> Computer Based Training (CBT) implementation going, and I'm fairly proud
> of how this first effort has turned out.

You should be -- very nice work!

> What I'm hoping to get is constructive feedback, as I've put as much
> time, thought, and effort into this first one as I know how to.  I'm
> talking HEAPS.  Suggestions of what should be the subject of the next
> CBT are also welcome.

Two minor comments:

First, in 7.2+ sequences are based on 8 byte integers on platforms which 
support them, so the default maxvalue is 9223372036854775807 instead of 

Second, the currval function returns the "value most recently obtained 
by nextval for this sequence in the current server process" -- i.e. it 
only shows the last value obtained in your own session, and will give an 
error if nextval has not already been called within the current session.

If you decide to do a CBT on use of the bytea data type, I'd be happy to 
try to help.

Take care (and Happy Holidays!),

-- Joe

In response to


pgsql-announce by date

Next:From: Bruce MomjianDate: 2001-12-28 17:52:52
Subject: Re: First decent PostgreSQL CBT now on
Previous:From: Dave PageDate: 2001-12-27 15:35:50
Subject: pgAdmin II 1.1.76 Released

pgsql-general by date

Next:From: Mark kirkwoodDate: 2001-12-28 11:04:25
Subject: Re: persistent connection using PHP and Transaction
Previous:From: Roland RobertsDate: 2001-12-28 05:25:36
Subject: Re: How to access array elements via PL/pgSQL trigger?

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