use Perl

• Array types (Score:2)

  by djberg96 (2603)

  Oh, good point. Is something like PostgreSQL's array type the proper solution here then?

  create table sometable (
     id serial,
     name varchar(50),
     email text[]
  );

  This would store a list of email addresses as a single object. Or have I missed the point again?

  In other news, I'm surprised PostgreSQL doesn't have an "email_address" type. It seems to have everything else.
  • Re:Array types (Score:2)

    by Theory (10) on 2006.04.21 11:36 (#47312) Homepage Journal

    In other news, I'm surprised PostgreSQL doesn't have an "email_address" type. It seems to have everything else.

    You can create one easily enough with a CREATE DOMAIN statement. Here's a naive implementation:

    CREATE DOMAIN email_address AS TEXT
    CONSTRAINT ck_email_address CHECK (
       VALUE ~ '^[^@]+@[^@]+$'
    );

    Modify the regular expression as needed to increase its accuracy. Then you can use it like any other PostgreSQL data type:

    CREATE TABLE person (
      id SERIAL PRIMARY KEY,
      name text,
      email email_address
    );

    Reply to This

    Parent