[Lispweb] clsql-pg-introspect

[Alan Shields]

On Wed, Aug 31, 2005 at 11:57:25AM +0200, R. Mattes wrote:
> On Tue, 2005-08-30 at 21:08 -0500, Alan Shields wrote:
> > Web apps often hook into databases, so I thought some of you might be
> > interested in my latest bit of code.
> > 
> 
> Here is the relevant psql listing for that table:
> 
>         Table "public.book"
>   Column  |     Type      | Modifiers 
> ----------+---------------+-----------
>  id       | text          | not null
>  class    | text          | 
>  title    | text          | 
>  info     | text          | 
>  subtitle | text          | 
>  year     | text          | 
>  isbn     | text          | 
>  price    | numeric(10,2) | 
>  pages    | text          | 
>  agelimit | integer       | 
> Indexes:
>     "book_id_idx" hash (id)
> Inherits: work
> 

Around line 130, add "(numeric 'number)"

Should look like this:

(timestamp 'walltime)
(numeric 'number)
(interval 'duration)

Give that a shot, lemme know if it works. If it does, I'll patch
and it'll go out with the next release.

Keep in mind that inheritance won't work just yet.

Alan