Re: Check existence of combination in an M.N relation

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: "Erik Cederstrand" <erik(at)cederstrand(dot)dk>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Check existence of combination in an M.N relation
Date: 2008-02-29 19:57:44
Message-ID: a55915760802291157p48012606p974602da7d3f0538@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Fri, Feb 29, 2008 at 10:25 AM, Erik Cederstrand <erik(at)cederstrand(dot)dk> wrote:
> How would I go about this?

This smells like EAV.

Please read

http://joecelkothesqlapprentice.blogspot.com/2006/04/using-one-table-vs-many.html

and consider reevaluating the schema according to valid relational
design (tables, columns, check constraints, etc.).

In any case, good luck.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio-Sr 2008-03-01 00:43:47 Re: pidof not working for postgresql-8.3 ?
Previous Message Erik Cederstrand 2008-02-29 15:25:42 Check existence of combination in an M.N relation