Re: [SQL] query or design question

2003-10-20 Thread Richard Huxton
On Monday 20 October 2003 11:58, Adam Witney wrote: > Hi, > > I have a table like so > > CREATE TABLE imagene ( > id int > bioassay_idint > gene_idtext > s_row int > s_column int > s_meta_row int > s_meta_column int > sig_median numeric > bkg_median

[SQL] query or design question

2003-10-20 Thread Adam Witney
Hi, I have a table like so CREATE TABLE imagene ( id int bioassay_idint gene_idtext s_row int s_column int s_meta_row int s_meta_column int sig_median numeric bkg_median numeric ); Rows are unique on (bioassay_id, gene_id, s_row, s_column, s_me