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

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