posted 17 years ago
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 ]