From: | javier garcia <rn001(at)cebas(dot)csic(dot)es> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | cross references queries |
Date: | 2005-07-01 14:38:39 |
Message-ID: | 200507011638.40179.rn001@cebas.csic.es |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)cebas(dot)csic(dot)es
From | Date | Subject | |
---|---|---|---|
Next Message | Bob | 2005-07-01 14:41:57 | Re: COnsidering a move away from Postgres |
Previous Message | Richard_D_Levine | 2005-07-01 14:32:34 | Re: COnsidering a move away from Postgres |