Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Edmonton Alberta Canada

    Unanswered: Table Design: null or not

    Hey, I have a table called sentence_grammar, which has gramma_id, subject, verb, noun, adjective, adverb, ...

    This is how it works: for example, if you have a sentence 'I love dbforums,' it will match to the grammar_id having

    subject assigned number 1
    verb assigned number 2
    noun assgned number 3

    And the rest assigned...

    That's my question, null or 0, which is better? And why?


  2. #2
    Join Date
    Sep 2001

    depends on your needs

    I think 0 ist better

    When you have null you must do a select afterwards

    SELECT * FROM xxx WHERE y < 2

    the nulls are not counted in some circumstances

    it is always better to use not null
    --Postgresql is the only kind of thing--

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts