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

2002-12-20 Thread Christoph Haller
> > 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 result. > >

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

2002-12-19 Thread javier garcia
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

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

2002-12-17 Thread Christoph Haller
> My problem is that I need to fill in the gaps (the available rain data in the > corresponding stations), and this would be a very good output for me. > I've prepared an UPDATE but it doesn't work. Perhaps someone could tell me > where is the error (I've not a very good knowledge of Postgresql). T

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

2002-12-16 Thread javier garcia
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 |