Results 1 to 2 of 2

Thread: conditioned table creation

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Feb 2006
    Location
    Transylvania
    Posts
    23

    conditioned table creation

    hi guys,

    I need to create a postgresql table with 2 columns
    name (text) and age (int) which contains two
    major conditions : the user cannot enter a name
    which begins with 'a' and a age lower than 10

  2. #2
    Fanatic Member kaffenils's Avatar
    Join Date
    Apr 2004
    Location
    Norway
    Posts
    946

    Re: conditioned table creation

    Quote Originally Posted by arizona2006
    hi guys,

    I need to create a postgresql table with 2 columns
    name (text) and age (int) which contains two
    major conditions : the user cannot enter a name
    which begins with 'a' and a age lower than 10
    You must use constraints. The PostgreSql documentation explains very good: http://www.postgresql.org/docs/8.1/s...nstraints.html

Posting Permissions

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



Click Here to Expand Forum to Full Width