• Post Reply Bookmark Topic Watch Topic
  • New Topic

SQL check constraint

 
Juhan Voolaid
Ranch Hand
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

It is only about SQL (DDL) and to be more specific - about PostgreSQL.

I have to create a table coordinates with rows: x integer, y integer, id integer, data_set integer. And I allso must specify that in one data_set, there is no dublicated set of coordinates.

My first attempt was like that:

But this one fails, because it does not care about data_set_ID.

So if there is any SQL guru out there, help is very welcome. How would you complete this, or what would you add to the code above?


thanx
[ June 11, 2006: Message edited by: Juhan Voolaid ]
 
Juhan Voolaid
Ranch Hand
Posts: 179
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Daaaahhhh ...

The solution is more simple than I could excpect in my wildest dreams:

UNIQUE (x, y, data_set_id)
 
Jeanne Boyarsky
author & internet detective
Sheriff
Posts: 36007
422
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Juhan,
Thanks for posting the solution for others who see this thread in the future.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!