Re: [GENERAL] Another windowed function with different values.

2017-02-01 Thread Edmundo Robles
this issue was raised by timezone settings ... On Wed, Feb 1, 2017 at 10:15 AM, Edmundo Robles wrote: > i just changed the jdbc, but still get the wrong values... > > On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles > wrote: > >> this issues could

[GENERAL] Another windowed function with different values.

2017-02-01 Thread Edmundo Robles
I have postgresql 9.4 and wrote a function get_ignition_time() to get the first time when a car was ignition on and the last time when ignition is off, those time stamps are used in another function get_fuel_consumption() to get the fuel consumption. The issue is when: 1. I run

Re: [GENERAL] Another windowed function with different values.

2017-02-01 Thread Edmundo Robles
this issues could be raised by a incorrect jdbc? the jdbc used is postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4 On Wed, Feb 1, 2017 at 9:35 AM, Edmundo Robles wrote: > > I have postgresql 9.4 and wrote a function get_ignition_time() to get > the first

Re: [GENERAL] Another windowed function with different values.

2017-02-01 Thread Edmundo Robles
i just changed the jdbc, but still get the wrong values... On Wed, Feb 1, 2017 at 9:47 AM, Edmundo Robles wrote: > this issues could be raised by a incorrect jdbc? the jdbc used is > postrgresql-9.2-1002.jdbc4.jar and i have a postgresql 9.4 > > On Wed, Feb 1, 2017