Re: [SQL] date question

2003-06-21 Thread javier garcia - CEBAS
f the mentioned table? (I've looked it in the documentation, but I can't find the answer) Thanks and regards, Javier El Mar 17 Jun 2003 20:09, escribió: > javier garcia - CEBAS writes: > > Is there a way to create a table from this table, directly in

[SQL] "No such attribute or function 'oid'"

2003-06-16 Thread javier garcia - CEBAS
Hi; I'm using ODBC driver for windows, because I use Excel (Microsoft) to work with data. When I try to get data from a Postgres table there is no problem; but when I try to acces a view I get the mesage: "No such attribute or function 'oid'" When I try to access views from ACCESS2000 there is n

[SQL] date question

2003-06-16 Thread javier garcia - CEBAS
Hi; I've got a table in the way: year | month | day | est7237 | est7238 | est7239 | est7250 --+---+-+-+-+-+- 2002 | 9 | 1 | | | | 2002 | 9 | 2 | | | | 2002 | 9 | 3 | |

[SQL] EXTERN JOIN with WHEN query

2003-06-07 Thread javier garcia - CEBAS
Hi all; This is a query that I guess is not very dificult, but I'm a newbie; I've got a lot of tables, each of them with two columns: SELECT * FROM precal; -> (date) (real) fecha| precipitacion +--- 1996-01-01 | 0.6 1996-02-01 | 0.7 ..