[image: Inline image 1]
RUN
[image: Inline image 2]
On Mon, Oct 5, 2015 at 6:36 PM, channara rin wrote:
> No record found...
>
> On Mon, Oct 5, 2015 at 6:21 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> What about
>>
>> SELECT * FROM period where startdate = '1975-01-01'::da
No record found...
On Mon, Oct 5, 2015 at 6:21 PM, Jason Pickering wrote:
> What about
>
> SELECT * FROM period where startdate = '1975-01-01'::date
>
>
>
> On Mon, Oct 5, 2015 at 12:30 PM, channara rin
> wrote:
>
>> Hi Jason,
>> I am using version 2.20 and Time zone: GMT+7:00
>>
>> On Mon, Oct
What about
SELECT * FROM period where startdate = '1975-01-01'::date
On Mon, Oct 5, 2015 at 12:30 PM, channara rin
wrote:
> Hi Jason,
> I am using version 2.20 and Time zone: GMT+7:00
>
> On Mon, Oct 5, 2015 at 5:24 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> What time zo
Hi Jason,
I am using version 2.20 and Time zone: GMT+7:00
On Mon, Oct 5, 2015 at 5:24 PM, Jason Pickering wrote:
> What time zone are you on and which version are you using?
>
>
> On Mon, Oct 5, 2015 at 12:02 PM, channara rin
> wrote:
>
>> thank you jason
>> by the way, i run already. but didn'
What time zone are you on and which version are you using?
On Mon, Oct 5, 2015 at 12:02 PM, channara rin
wrote:
> thank you jason
> by the way, i run already. but didn't see any record show up
>
> On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> And y
thank you jason
by the way, i run already. but didn't see any record show up
On Mon, Oct 5, 2015 at 4:41 PM, Jason Pickering wrote:
> And you may want to be careful about deleting anything as there may be
> data attached to one of those periods. You should of course make a backup
> before you at
And you may want to be careful about deleting anything as there may be data
attached to one of those periods. You should of course make a backup before
you attempt to delete anything, and then find any data which is referencing
the duplicate period. There are quite a few tables which reference
"per
Still some typos...
SELECT * FROM period WHERE (startdate, enddate) IN
(SELECT startdate, enddate FROM period GROUP BY startdate, enddate HAVING
count(*) >1)
On Mon, Oct 5, 2015 at 11:37 AM, Knut Staring wrote:
> Oops, wrong order. Should be like this, I think:
>
>
> SELECT * FROM period WHERE
Oops, wrong order. Should be like this, I think:
SELECT * FROM period WHERE startdata, enddate IN
(SELECT startdate, endedate FROM period GROUP BY startdate, enddate HAVING
count(*) >1)
On Mon, Oct 5, 2015 at 11:36 AM, Knut Staring wrote:
> The table is called period.
>
> But please first run
The table is called period.
But please first run this query:
SELECT * FROM period WHERE startdata, enddate IN
(SELECT startdate, endedate FROM period HAVING count(*) >1 GROUP BY
startdate, enddate)
On Mon, Oct 5, 2015 at 11:33 AM, channara rin
wrote:
> so you mean, i can delete row from table?
period table but make sure you delete only that row.
Alex
On Mon, Oct 5, 2015 at 12:33 PM, channara rin
wrote:
> so you mean, i can delete row from table? which table should i can delete
> that row?
>
> On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye
> wrote:
>
>> Dear Channara,
>>
>> Which ve
so you mean, i can delete row from table? which table should i can delete
that row?
On Mon, Oct 5, 2015 at 4:20 PM, Alex Tumwesigye
wrote:
> Dear Channara,
>
> Which version are you running? This bug was fixed. It is related to
> timezone I f I remember very well.
> If you check your period tabl
Dear Channara,
Which version are you running? This bug was fixed. It is related to
timezone I f I remember very well.
If you check your period table, there are invalid ranges for 1975-01-01.
Just delete the invalid ranges and you will be fine.
Alex
On Mon, Oct 5, 2015 at 12:14 PM, channara rin
13 matches
Mail list logo