Postgres Pro
Downloads
Home   >   mailing lists

Re: Composite UNIQUE across two tables? - Mailing list pgsql-sql

From Rodrigo E. De León Plicet
Subject Re: Composite UNIQUE across two tables?
Date
Msg-id a55915760803111331y275fd1e6s24e46ce4aaf73ce0@mail.gmail.com
Whole thread Raw
In response to Re: Composite UNIQUE across two tables?  ("Dirk Jagdmann" <jagdmann@gmail.com>)
List pgsql-sql
Tree view 
On Tue, Mar 11, 2008 at 2:03 PM, Dirk Jagdmann <jagdmann@gmail.com> wrote:
>  For my tests, I have modified your posted schema a bit, to
>  unify all column names to "name".

OT and IMHO, this is not good practice. Column names should be unique
and descriptive throughout the entire schema.

pgsql-sql by date:

Previous
From: "Dirk Jagdmann"
Date:
Subject: Re: Composite UNIQUE across two tables?
Next
From: Emi Lu
Date:
Subject: case when... end in update clause?