>psql:/home/../temp/postgres/marray2/view.sql:58:
>ERROR: column reference "fc_probe_set_id" is ambiguous
You have to use the "table.column" notation. E.g.
"table12.fc_probe_set_id" instead of just "fc_probe_set_id"
Cheers,
Marc
>In my case every table (13 numbers) has 20 columns and
>column names are identical.
>In the select statement it is difficult to specify
>every table name . column name and do this for 20
>times for every chip.
You obviously have to; since all column names are identical how could
you hope PostgreSQL to be sure which table you mean?