Re: [SQL] date question

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'"

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

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

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 ..

Re: [SQL] UPDATE with a SELECT and subSELECT(About comparing dates and non dates data)

Thanks Christoph; Typing what you told me there was an errror; I' ve changed it slightly an it seems that this sintax is correct. I say "it seems" because the computer begins to process the query but doesn't finish it. I've leaved it working for more than half an hour, before cancel it, with no

[SQL] UPDATE with a SELECT and subSELECT(About comparing dates and non dates data)

Thanks Josh and Bret for your answers. But I think I can try a slightly different thing. As I said, I've got data, extracted from rain gauge stations. Perhaps I wasn't explicit enough. My source data are in this format: cod_variable | cod_station | year | month | ten | rain_day1 | wind_day1 |

[SQL] UPDATE comparing dates and non-dates data

Hi; I've got date data, extracted from rain gauge stations. The date of a row in my data are structured in three integer fields, and as a result of a query I can get the following (what is quite good for my): cod_station | year | month | day | rain -+--+---+-+-- 7250

[SQL] union query doubt:

Hi; I've got a table with three fields: DATE, POINT, FLOW. The POINT field can have values among 1 and 6. So, for a same date I have six different points with the correspondings flows. I would like to make a query to obtain something like: DATE POINT1 POINT2 POINT3 POINT4 POINT5 POINT6 where for

[SQL] Query about table and catalog

Hi; I've got a table with several fields. Among others there are the fields 'soil1', 'soil2', and 'soil3' that are char type. A row can have an empty value in one of these fields, or the three fields can have valid values: cod_grass |suelo1|suelo2 | suelo3

[SQL] ORDER the result of a query by date

Hello; I've got the result of a query that appears as: cod_variable | cod_station | year | month | day | rain -+---++--+--+-- 30201 | 7237 | 1953 |1 | 1 |2 30201 | 7237 | 1953 |

[SQL] Basic question.

Hi; I'm sorry for ask this basic question. But I can't find in the documentation. I'm connected to a database; and how can I execute a query that I've got in a file? And. If I'm not connected to any database. Can I execute a file that makes a query on a database? Thanks - Javi

[SQL] Hairy question - transpose columns

Hello; I've got pluviometric data in a bizarre format (spanish administration is rather original) and I need to "transpose" them, to be able to use them as time series data for a model. The original data are in a format like cod_var | Year | Month | Ten | RainDay1 | RainDay2 | RainDay3 |

[SQL] odbc drivers

Hi; I've got PostgreSQL 7.2 and I would like to use MSAccess2k as a front end; in a LAN, because some of my colleagues just use Windows. Where could I find a ODBC driver for Postgresql to be use under windows2000? thanks and regards -- Javier ---(end of broadca

[SQL] new calculated column

Hi; I've got a table with two fields and about 3000 rows, the second one is a character field, what can have about twenty different values; of course these values are repeated a lot of times in the table. I need to create a new column of type integer, whose value depens on the character fields

[SQL] new calculated column

Hi; I've got a table with two fields and about 3000 rows, the second one is a character field, what can have about twenty different values; of course these values are repeated a lot of times in the table. I need to create a new column of type integer, whose value depens on the character fields. T