Dear Group,
I have two tables:
1.
exp_id | exp_name | exp_type | exp_desc | exp_logic
--------+----------+----------+----------+----------
2.
data_id | exp_id | data_present | data_past |
data_mean
---------+--------+--------+--------+------------------
I have my data_present, data_past and data_mean in a
text file. I have my exp_id in experiment table.
Now I have to load 10 different experimental data
(exp_id range : 1-10)
How can I tell postgresql :
1. from which data_id my exp_id changes. For example
data_id from 1 to 100 will be exp_id : 1 and data_id :
101-200 will be exp_id : 2. How will I know what was
the last data_id number and ask postgres to take the
next row as next exp_id.
Please help.
Thank you.
Srini
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com