Re: I often have to do "update if exist, else insert", is my database design wrong?

From: Richard Huxton <dev(at)archonet(dot)com>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I often have to do "update if exist, else insert", is my database design wrong?
Date: 2008-07-25 09:18:26
Message-ID: 48899A62.5020704@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A B wrote:
>
> Or is there some more general problem with the table design?
> table_XY is in this case (and most cases) a table like this
>
> create table table_XY (
> x int references table_X,
> y int references table_Y
> );

Without knowing what XY are and what you are using table_XY for it's
going to be difficult for anyone to offer useful advice.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A B 2008-07-25 09:52:56 Subselect with limit
Previous Message A B 2008-07-25 08:52:11 I often have to do "update if exist, else insert", is my database design wrong?