pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PostgreSQL Admin <postgres@productivitymedia.com>
To: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Add constraint for number of chars
Date: Thu, 26 Apr 2007 00:41:44 -0400
Message-ID: <46302D88.7070804@productivitymedia.com> (raw)

Hi,

This is seemly simple, but I'm @ a loss this early in the morning.  It's
best explained this way

SAMPLE
-----------------------------------
id                  | serial            |
username   | varchar(100)| constraint username >=8 and username <=100

The problem is that it's characters not integers or numeric.  It my
constraint correct?

Thanks for the help,
J



view thread (2+ messages)  latest in thread

Message-ID: <46302D88.7070804@productivitymedia.com>
Permalink:  ../46302D88.7070804@productivitymedia.com/
Also on:    postgresql.org/message-id/46302D88.7070804@productivitymedia.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: postgres@productivitymedia.com
  Subject: Re: Add constraint for number of chars
  In-Reply-To: <46302D88.7070804@productivitymedia.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox