UserFriendly Strip Comments


	The Daily Static UF Archives Register UF Membership Ad Free Site Postcards Community Geekfinder UFie Gear Advertise on UF Forum Rules & FAQ Username Password Create a New Account

Back to UserFriendly Strip Comments Index

One of the favorite data modeling tricks	by SnappingTurtle	2004-12-14 15:05:20
An example: prime smallint check (prime in (1)) So, somebody explain the purpose in having a check constraint that only allows `prime` to equal one value. Hint: the assumption in the above sentence isn't strictly true, depending on how you look at it.
[ Reply ]
Perhaps it's just a flag. 1 is prime, 0 is not. (n/t)	by williamashbless	2004-12-14 15:29:34
But the field can't have a value of 0 (n/t)	by SnappingTurtle	2004-12-14 15:36:04
I'm not particularly up on "check" constraints,	by LionsPhil	2004-12-14 15:52:03
I think you're teh winnar ;)	by chrisP	2004-12-14 16:19:25
s/the/my/ (n/t)	by SnappingTurtle	2004-12-14 15:36:33

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)