hi
(B I have some trouble updating a table like this one :
(B date | data_raw | data_sys
(B 12-01 | 5 | 4.5
(B 13-01 | 6 | 6
(B 14-01 | 7 | 8
(B
(BI would like to update the 'data_sys' ro
Hi,
I have a table with this columns: machine, date and area.
Now i need a view with machine an week, calculated from date, and
sum(area), where date between CURRENT_DATE and now+N days.
Okay, this is not the problem, it works fine.
(the original table and the view is more complex)
The problem
On Sat, Jan 22, 2005 at 12:51:20PM +, adam etienne wrote:
>
> I have some trouble updating a table like this one :
> date | data_raw | data_sys
> 12-01 | 5 | 4.5
> 13-01 | 6 | 6
> 14-01 | 7 |
Hi I am doing my work in windows attached to a postgres server on linux
fedora core3.
I have been using pgadminIII and amd am trying the demo of EMS.
My question is I dont see an easy way to find an error.
Typical error text is syntax error at or near "trans" at character 825
But determining cha
"Joel Fradkin" <[EMAIL PROTECTED]> writes:
> My question is I dont see an easy way to find an error.
> Typical error text is syntax error at or near "trans" at character 825
> But determining character 825 is a little slow by hand.
PG 8.0 produces more useful output. A trivial example:
regressi
Very cool (I tried to get 8 on fedora, but think I was missing it somehow.).
I also noticed if I run in EMS (course I need to buy it)it positions me on
the error if I am in the editor not the builder.
I am a little afraid of using 8 as it is brand new, and this will be on a
production machine. I c
On Jan 22, 2005, at 5:12 PM, Joel Fradkin wrote:
My question is I don’t see an easy way to find an error.
Typical error text is syntax error at or near "trans" at character 825
But determining character 825 is a little slow by hand.
In pgEdit you can use the "Goto Point" command to jump to a specif
