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 Ovid (2709) on 2006.04.21 11:54 (#47313) Homepage Journal

    As Theory points out, you can create such a type. The problem is that if anything else needs to reference data within that type, Postgres does not allow any convenient way of doing so. This makes it pretty difficult to use Postgres for MV purposes.

    Reply to This

    Parent

    • Re:Array types (Score:1)

      by iburrell (4155)

      PostgreSQL actually supports composite types.

      CREATE TYPE inventory_item AS (
          name            text,
          supplier_id     integer,
          price           numeric
      );
      
      CREATE TABLE on_hand (
          item      inventory_item,
          count     integer
      );
      
      SELECT (item).supplier_id FROM on_hand;

      It sounds like PostgreSQL even automatically makes a composite type for each table