cross references queries
cross references queries
От:
javier garcia <rn001@cebas.csic.es>
Дата:
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
Re: cross references queries
От:
Michael Fuhr <mike@fuhr.org>
Дата:
On Fri, Jul 01, 2005 at 04:38:39PM +0200, javier garcia wrote: > > 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. The contrib/tablefunc module might be able to do what you want. -- Michael Fuhr http://www.fuhr.org/~mfuhr/
