Postgres Pro
Downloads
Home   >   mailing lists

Re: Check existence of combination in an M.N relation - Mailing list pgsql-novice

From Rodrigo E. De León Plicet
Subject Re: Check existence of combination in an M.N relation
Date
Msg-id a55915760802291157p48012606p974602da7d3f0538@mail.gmail.com
Whole thread Raw
In response to Check existence of combination in an M.N relation  (Erik Cederstrand <erik@cederstrand.dk>)
List pgsql-novice
Tree view 
On Fri, Feb 29, 2008 at 10:25 AM, Erik Cederstrand <erik@cederstrand.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.

pgsql-novice by date:

Previous
From: Erik Cederstrand
Date:
Subject: Check existence of combination in an M.N relation
Next
From: Ennio-Sr
Date:
Subject: Re: pidof not working for postgresql-8.3 ?