Hello all.
In MSAccess there is a type of query that directly can create a view in which
every distinct value of a column in a table becomes the name of a diferent
column in the view.
It is something like:
Table:
date point value1 value2
-------------------------------------
12/03/1999 pto1 3.4 34.5
12/03/1999 pto2 2.3 5.46
13/04/2004 pto1 2.1 3.45
13/04/2004 pto2 6.3 9.43
...
resulting View_value1:
date pto1 pto2
--------------------------
12/03/1999 3.4 2.3
13/04/2004 2.1 6.3
...
This is called the corrs references views in MSAccess.
Please, is it posible to do this directly in postgres or we need to do it
using a lot of OUT JOINS for the diferent points in the view?
Thanks and best wishes,
Javier
--
A. Javier Garcia
Water and Soil conservation department
CEBAS-CSIC
Campus Universitario Espinardo
PO BOX 164
30100 Murcia (SPAIN)
Phone: +34 968 39 62 57
Fax: +34 968 39 62 13
email: rn001@cebas.csic.es