Re: [SQL] Looking for comments

2001-01-02 Thread Peter Eisentraut
Thomas SMETS writes: > > ISBN's have a checkdigit; it would be sensible to provide a > function to be used in a CHECK constraint to ensure that the > ISBN is valid. > > > OK I'll start searching for it but haven't implemented yet In the PostgreSQL distribution there's a directory contrib/isbn_

Re: [SQL] Looking for comments

2001-01-02 Thread Ron Peterson
Thomas SMETS wrote: > > > ISBN's have a checkdigit; it would be sensible to provide a > function to be used in a CHECK constraint to ensure that the > ISBN is valid. > Here's a URL with more information:http://www.isbn.spk-berlin.de/html/userman/usm4.htm. I've written a similar algorithm in

Re: [SQL] Looking for comments

2000-12-30 Thread Thomas SMETS
1. General comment: you use lettercase to divide words in table and fieldnames; this will be lost as soon as you create the tables, because PostgreSQL folds everything to lower case. Use _ to separate words instead. OK it should be done everywhere where I did some changes, at least. I

[Fwd: [SQL] Looking for comments]

2000-12-29 Thread Thomas SMETS
> > Hi Thomas, I would love to help. > Najm > What are your competences ? Needed is java <--> Basic devlopment in Java 2 php <--> Currently hosting free may buy web site later on python <--> Install & config done via Python Admin <--> What to Config, How, Custo

Re: [SQL] Looking for comments

2000-12-29 Thread Thomas SMETS
Oliver, At the moment Tx for all your remarks... I'll need some times to digest them all! I'll keep this thread inform on updates Regards, Thomas Oliver Elphick wrote: > > Thomas SMETS wrote: > > > >Rather thant making long sentences & comment. > >Anyone wi

[SQL] Looking for comments

2000-12-28 Thread Thomas SMETS
Rather thant making long sentences & comment. Anyone willing to give me a little help on this tables definition is welcome http://lautre.org/tsmets/DB.html Tomorrow the pageswill be colorized a little bit more & a drawing of the expected tables will be provided. Tx, Thomas, -- Thu Dec 28