RE: [sqlite] Restricting integer primary key values

2007-01-15 Thread Brett Keating
me but hey you never know). Thanks for the replies, Brett -Original Message- From: w b [mailto:[EMAIL PROTECTED] Sent: Monday, January 15, 2007 11:42 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Restricting integer primary key values Hi Brett, I dont think that there is a way wit

Re: [sqlite] Restricting integer primary key values

2007-01-15 Thread Clark Christensen
- Original Message From: w b <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, January 15, 2007 11:41:39 AM Subject: RE: [sqlite] Restricting integer primary key values Hi Brett, I dont think that there is a way within Sqlite to automagically do what you are looking for.

RE: [sqlite] Restricting integer primary key values

2007-01-15 Thread w b
Sunday, January 14, 2007 6:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Restricting integer primary key values "Brett Keating" wrote: > Hi, > > I don't want to spam the list but basically, if "id INTEGER PRIMARY > KEY CHECK (id > 0 and id < 0xFF

RE: [sqlite] Restricting integer primary key values

2007-01-15 Thread Brett Keating
. I will continue trying other things in the meantime. Thanks, Brett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 14, 2007 6:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Restricting integer primary key values "Brett Keating&quo

Re: [sqlite] Restricting integer primary key values

2007-01-14 Thread drh
"Brett Keating" <[EMAIL PROTECTED]> wrote: > Hi, > > I don't want to spam the list but basically, if "id INTEGER PRIMARY KEY > CHECK (id > 0 and id < 0x)" or something along those lines will > work, please let me know. It's not clear if sqlite3 supports checks on > primary keys from what

RE: [sqlite] Restricting integer primary key values

2007-01-14 Thread Brett Keating
Original Message- From: Brett Keating [mailto:[EMAIL PROTECTED] Sent: Sunday, January 14, 2007 5:14 PM To: sqlite-users@sqlite.org Subject: [sqlite] Restricting integer primary key values Hi, I'm interested in the ability to restrict the values my integer primary key is allowed to take. Specifical

[sqlite] Restricting integer primary key values

2007-01-14 Thread Brett Keating
Hi, I'm interested in the ability to restrict the values my integer primary key is allowed to take. Specifically, I would like to restrict the value to be between (but not including) 0x and 0x. In other words, a 32 bit number where all zeroes and all ones is not allowed. Is this