Обсуждение: Loading data

Поиск
Список
Период
Сортировка

Loading data

От
Srinivas Iyyer
Дата:
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