[h2] Only show changes in GROUP BY

[Cecil Westerhof]

I have the following SQL:
SELECT   date  AS Date
,SUBSTRING(time, 1, 2) AS Hour
,MIN(idleTime) AS `Min Idle`
,MAX(idleTime) AS `Max Idle`
,COUNT(*)  AS SUM
FROM vmstatDefault
GROUP BY Date
,Hour
ORDER BY Date
,Hour
;

This works fine, but I would prefer to only have Date shown when it is
different as the previous Date. Is this possible?

-- 
Cecil Westerhof

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Noel Grandin]

On 2014-01-09 23:43, Cecil Westerhof wrote:

This works fine, but I would prefer to only have Date shown when it is 
different as the previous Date. Is this possible?


Depends on what you mean by "previous date"?
You didn't show the table definition, so it's hard to know.

In general, filtering when you are using GROUP BY means using a HAVING clause.

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Ryan How]

Wouldn't you usually do that in your reporting software? Or on any layer 
on top of the database?


In MS Access I've done it using a custom function which stores the last 
value and then only outputs the next value if it is different. Not sure 
how to do that in H2 ? Probably via a custom function again?


I'm not sure of other ways to make 1 row aware of the previous rows 
value so you can run a calculation off it.


Can you put it into a temp table with row numbers, then join the temp 
table to itself in a query to get the previous rows date value, then run 
a calculation off that whether to display the date or not?



On 10/01/2014 5:43 AM, Cecil Westerhof wrote:

I have the following SQL:
SELECT   date  AS Date
,SUBSTRING(time, 1, 2) AS Hour
,MIN(idleTime) AS `Min Idle`
,MAX(idleTime) AS `Max Idle`
,COUNT(*)  AS SUM
FROM vmstatDefault
GROUP BY Date
,Hour
ORDER BY Date
,Hour
;

This works fine, but I would prefer to only have Date shown when it is 
different as the previous Date. Is this possible?


--
Cecil Westerhof
--
You received this message because you are subscribed to the Google 
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to h2-database+unsubscr...@googlegroups.com.

To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.


--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Cecil Westerhof]

2014/1/10 Noel Grandin 

>
>
> On 2014-01-09 23:43, Cecil Westerhof wrote:
>
>> This works fine, but I would prefer to only have Date shown when it is
>> different as the previous Date. Is this possible?
>>
>
> Depends on what you mean by "previous date"?
> You didn't show the table definition, so it's hard to know.
>
> In general, filtering when you are using GROUP BY means using a HAVING
> clause.
>

The definition (that is important, I removed 16 fields) is:
CREATE  TABLE vmstatDefault (
dateDATE DEFAULT CURRENT_DATE() NOT NULL,
timeTIME DEFAULT CURRENT_TIME() NOT NULL,
idleTimeINT,

PRIMARY KEY (date, time)
);

I use:
SELECT   date  AS Date
,SUBSTRING(time, 1, 2) AS Hour
,MIN(idleTime) AS `Min Idle`
,MAX(idleTime) AS `Max Idle`
,COUNT(*)  AS SUM
FROM vmstatDefault
GROUP BY Date
,Hour
ORDER BY Date DESC
,Hour DESC


This gives:
DATEHOUR  MIN IDLE  MAX IDLE  SUM
2014-01-11098795   45
2014-01-11089395   60
2014-01-11079495   60
2014-01-11069595   60
2014-01-11059595   60
2014-01-11049495   60
2014-01-11039595   60
2014-01-11029595   60
2014-01-11019595   60
2014-01-11009595   60
2014-01-10238696   60
2014-01-10228797   60
2014-01-10219297   60

But I would like to get:
DATEHOUR  MIN IDLE  MAX IDLE  SUM
2014-01-11098795   45
  089395   60
  079495   60
  069595   60
  059595   60
  049495   60
  039595   60
  029595   60
  019595   60
  009595   60
2014-01-10238696   60
  228797   60
  219297   60

That I can not do what HAVING (as far as I know). I have done something
like this about 15 years ago. But it is possible that this was an extension
to SQL and not standard SQL. I just do not remember what I did. :-(

-- 
Cecil Westerhof

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Atul Chowdhury]

You're probably after something like the BREAK directive found in SQL*Plus.

See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm

SQL> BREAK ON DEPTNO
SQL> SELECT DEPTNO, ENAME, SAL
  2  FROM EMP
  3  WHERE SAL < 2500
  4  ORDER BY DEPTNO;
SQL*Plus displays the following output:
DEPTNO ENAME SAL
-- --- -
10 CLARK2450
   MILLER   1300
20 SMITH 800
   ADAMS1100
30 ALLEN1600
   JAMES 950
   TURNER   1500
   WARD 1250
   MARTIN   1250



On Sat, Jan 11, 2014 at 4:02 AM, Cecil Westerhof wrote:

>   2014/1/10 Noel Grandin 
>
>>
>>
>> On 2014-01-09 23:43, Cecil Westerhof wrote:
>>
>>> This works fine, but I would prefer to only have Date shown when it is
>>> different as the previous Date. Is this possible?
>>>
>>
>> Depends on what you mean by "previous date"?
>> You didn't show the table definition, so it's hard to know.
>>
>> In general, filtering when you are using GROUP BY means using a HAVING
>> clause.
>>
>
> The definition (that is important, I removed 16 fields) is:
> CREATE  TABLE vmstatDefault (
> dateDATE DEFAULT CURRENT_DATE() NOT NULL,
> timeTIME DEFAULT CURRENT_TIME() NOT NULL,
> idleTimeINT,
>
> PRIMARY KEY (date, time)
> );
>
> I use:
>
> SELECT   date  AS Date
> ,SUBSTRING(time, 1, 2) AS Hour
> ,MIN(idleTime) AS `Min Idle`
> ,MAX(idleTime) AS `Max Idle`
> ,COUNT(*)  AS SUM
> FROM vmstatDefault
> GROUP BY Date
> ,Hour
> ORDER BY Date DESC
> ,Hour DESC
>
>
> This gives:
> DATEHOUR  MIN IDLE  MAX IDLE  SUM
> 2014-01-11098795   45
> 2014-01-11089395   60
> 2014-01-11079495   60
> 2014-01-11069595   60
> 2014-01-11059595   60
> 2014-01-11049495   60
> 2014-01-11039595   60
> 2014-01-11029595   60
> 2014-01-11019595   60
> 2014-01-11009595   60
> 2014-01-10238696   60
> 2014-01-10228797   60
> 2014-01-10219297   60
>
> But I would like to get:
> DATEHOUR  MIN IDLE  MAX IDLE  SUM
> 2014-01-11098795   45
>   089395   60
>   079495   60
>   069595   60
>   059595   60
>   049495   60
>   039595   60
>   029595   60
>   019595   60
>   009595   60
> 2014-01-10238696   60
>   228797   60
>   219297   60
>
> That I can not do what HAVING (as far as I know). I have done something
> like this about 15 years ago. But it is possible that this was an extension
> to SQL and not standard SQL. I just do not remember what I did. :-(
>
> --
> Cecil Westerhof
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Cecil Westerhof]

2014/1/11 Atul Chowdhury 

> You're probably after something like the BREAK directive found in SQL*Plus.
>
> See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm
>
> SQL> BREAK ON DEPTNO
> SQL> SELECT DEPTNO, ENAME, SAL
>   2  FROM EMP
>   3  WHERE SAL < 2500
>   4  ORDER BY DEPTNO;
> SQL*Plus displays the following output:
> DEPTNO ENAME SAL
> -- --- -
> 10 CLARK2450
>MILLER   1300
> 20 SMITH 800
>ADAMS1100
> 30 ALLEN1600
>JAMES 950
>TURNER   1500
>WARD 1250
>MARTIN   1250
>

Yes, that is exactly what I want. This is not possible in H2?

-- 
Cecil Westerhof

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Atul Chowdhury]

No, I'm afraid not.  What's your final output? If its a report, you may
want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this
requirement.

On Sat, Jan 11, 2014 at 8:49 AM, Cecil Westerhof wrote:

>   2014/1/11 Atul Chowdhury 
>
>> You're probably after something like the BREAK directive found in
>> SQL*Plus.
>>
>> See: http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm
>>
>> SQL> BREAK ON DEPTNO
>> SQL> SELECT DEPTNO, ENAME, SAL
>>   2  FROM EMP
>>   3  WHERE SAL < 2500
>>   4  ORDER BY DEPTNO;
>> SQL*Plus displays the following output:
>> DEPTNO ENAME SAL
>> -- --- -
>> 10 CLARK2450
>>MILLER   1300
>> 20 SMITH 800
>>ADAMS1100
>> 30 ALLEN1600
>>JAMES 950
>>TURNER   1500
>>WARD 1250
>>MARTIN   1250
>>
>
> Yes, that is exactly what I want. This is not possible in H2?
>
> --
> Cecil Westerhof
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Ryan How]

If the timestamps are unique you could try including a subquery which 
gets the next lowest date


eg. (not sure if this is valid SQL syntax, I'm not meant to be on the PC 
:) Select data, datetimefield, (select top 1 datetimefield from table1 
where datetimefield < A.datetimefield order by datetimefield desc) as 
prevdatetime from table1 as A order by datetimefield


then you can use the previous date/time to calc whether to show the 
date/time for not






On 12/01/2014 1:06 PM, Atul Chowdhury wrote:
No, I'm afraid not.  What's your final output? If its a report, you 
may want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy 
this requirement.


On Sat, Jan 11, 2014 at 8:49 AM, Cecil Westerhof 
mailto:cldwester...@gmail.com>> wrote:


2014/1/11 Atul Chowdhury mailto:atulsmail...@gmail.com>>

You're probably after something like the BREAK directive found
in SQL*Plus.
See:
http://docs.oracle.com/cd/A84870_01/doc/sqlplus.816/a75664/ch42.htm
SQL> BREAK ON DEPTNO
SQL> SELECT DEPTNO, ENAME, SAL
  2  FROM EMP
  3  WHERE SAL < 2500
  4  ORDER BY DEPTNO;
SQL*Plus displays the following output:
DEPTNO ENAME SAL
-- --- -
10 CLARK2450
   MILLER   1300
20 SMITH 800
   ADAMS1100
30 ALLEN1600
   JAMES 950
   TURNER   1500
   WARD 1250
   MARTIN   1250


Yes, that is exactly what I want. This is not possible in H2?

-- 
Cecil Westerhof
-- 
You received this message because you are subscribed to the Google

Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to h2-database+unsubscr...@googlegroups.com
.
To post to this group, send email to h2-database@googlegroups.com
.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.


--
You received this message because you are subscribed to the Google 
Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send 
an email to h2-database+unsubscr...@googlegroups.com.

To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.


--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Cecil Westerhof]

2014/1/12 Atul Chowdhury 

> No, I'm afraid not.  What's your final output? If its a report, you may
> want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this
> requirement.
>

It is done in the web-browser. But I am making some bash scripts to do
things. In those  I could solve it.

-- 
Cecil Westerhof

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Thomas Mueller]

Hi,

H2 supports "running totals" in the MySQL style. Maybe the following could
be used as a start:

drop table test;
create table test(year int, month int);
insert into test values(2000, 1), (2000, 2), (2000, 3), (2001, 1);
select @y := case when rownum()=1 then year
  when @y = year then null else year end, month
from test group by year, month order by year, month

If you need more details, maybe best look / ask at StackOverflow and use
the "MySQL".

Regards,
Thomas



On Sunday, January 12, 2014, Cecil Westerhof wrote:

> 2014/1/12 Atul Chowdhury  'cvml', 'atulsmail...@gmail.com');>>
>
>> No, I'm afraid not.  What's your final output? If its a report, you may
>> want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this
>> requirement.
>>
>
> It is done in the web-browser. But I am making some bash scripts to do
> things. In those  I could solve it.
>
> --
> Cecil Westerhof
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com  'cvml', 'h2-database%2bunsubscr...@googlegroups.com');>.
> To post to this group, send email to 
> h2-database@googlegroups.com 'h2-database@googlegroups.com');>
> .
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Cecil Westerhof]

Looks that this only works on a line base. The value of @y is constantly
changed. When using:
DROP TABLE IF EXISTS test
;
CREATE TABLE test(
yearINT,
month   INT)
;
INSERT INTO test
(year, month)
VALUES
(2000, 1),
(2000, 2),
(2000, 3),
(2000, 4),
(2000, 5),
(2000, 6),
(2001, 1)
;
SELECT  @y
,   year
,   @y := CASE WHEN ROWNUM()=1 THEN year
WHEN @y = year THEN NULL ELSE year END
,   month
FROMtest
GROUP BYyear
,   month
ORDER BYyear
,   month
;
DROP TABLE test
;


I get:
2001200020001
20002000null2
null200020003
20002000null4
null200020005
20002000null6
null200120011

2014/1/14 Thomas Mueller 

> Hi,
>
> H2 supports "running totals" in the MySQL style. Maybe the following could
> be used as a start:
>
> drop table test;
> create table test(year int, month int);
> insert into test values(2000, 1), (2000, 2), (2000, 3), (2001, 1);
> select @y := case when rownum()=1 then year
>   when @y = year then null else year end, month
> from test group by year, month order by year, month
>
> If you need more details, maybe best look / ask at StackOverflow and use
> the "MySQL".
>
> Regards,
> Thomas
>
>
>
> On Sunday, January 12, 2014, Cecil Westerhof wrote:
>
>> 2014/1/12 Atul Chowdhury 
>>
>>> No, I'm afraid not.  What's your final output? If its a report, you may
>>> want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this
>>> requirement.
>>>
>>
>> It is done in the web-browser. But I am making some bash scripts to do
>> things. In those  I could solve it.
>>
>> --
>> Cecil Westerhof
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to h2-database+unsubscr...@googlegroups.com.
>> To post to this group, send email to h2-database@googlegroups.com.
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>  --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>



-- 
Cecil Westerhof

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [h2] Only show changes in GROUP BY

[Thomas Mueller]

Hi,

OK I see, what about:

DROP TABLE IF EXISTS test;
CREATE TABLE test(year INT, month INT);
INSERT INTO test (year, month) VALUES
(2000, 1), (2000, 2), (2000, 3), (2000, 4),
(2000, 5), (2000, 6), (2001, 1), (2002, 2), (2002, 3),
;
SELECT rownum(), year, month,
  @prev := case when rownum()=1 then null else @prev end prev_year,
  case when year = @prev then null else year end changed_year,
  @prev := year as year
FROM (select year, month from test group by year, month order by year,
month)
order by year, month;
DROP TABLE test;

Regards,
Thomas



On Tue, Jan 14, 2014 at 11:22 AM, Cecil Westerhof wrote:

> Looks that this only works on a line base. The value of @y is constantly
> changed. When using:
> DROP TABLE IF EXISTS test
> ;
> CREATE TABLE test(
> yearINT,
> month   INT)
> ;
> INSERT INTO test
> (year, month)
> VALUES
>
> (2000, 1),
> (2000, 2),
> (2000, 3),
> (2000, 4),
> (2000, 5),
> (2000, 6),
> (2001, 1)
> ;
> SELECT  @y
> ,   year
> ,   @y := CASE WHEN ROWNUM()=1 THEN year
> WHEN @y = year THEN NULL ELSE year END
> ,   month
> FROMtest
> GROUP BYyear
> ,   month
> ORDER BYyear
> ,   month
> ;
> DROP TABLE test
> ;
>
>
> I get:
> 2001200020001
> 20002000null2
> null200020003
> 20002000null4
> null200020005
> 20002000null6
> null200120011
>
> 2014/1/14 Thomas Mueller 
>
>> Hi,
>>
>> H2 supports "running totals" in the MySQL style. Maybe the following
>> could be used as a start:
>>
>> drop table test;
>> create table test(year int, month int);
>> insert into test values(2000, 1), (2000, 2), (2000, 3), (2001, 1);
>> select @y := case when rownum()=1 then year
>>   when @y = year then null else year end, month
>> from test group by year, month order by year, month
>>
>> If you need more details, maybe best look / ask at StackOverflow and use
>> the "MySQL".
>>
>> Regards,
>> Thomas
>>
>>
>>
>> On Sunday, January 12, 2014, Cecil Westerhof wrote:
>>
>>> 2014/1/12 Atul Chowdhury 
>>>
 No, I'm afraid not.  What's your final output? If its a report, you may
 want to consider a reporting tool ( Jasper/BIRT/etc ) to satisfy this
 requirement.

>>>
>>> It is done in the web-browser. But I am making some bash scripts to do
>>> things. In those  I could solve it.
>>>
>>> --
>>> Cecil Westerhof
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "H2 Database" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to h2-database+unsubscr...@googlegroups.com.
>>> To post to this group, send email to h2-database@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/h2-database.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>  --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to h2-database+unsubscr...@googlegroups.com.
>> To post to this group, send email to h2-database@googlegroups.com.
>> Visit this group at http://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
>
>
> --
> Cecil Westerhof
>
> --
> You received this message because you are subscribed to the Google Groups
> "H2 Database" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to h2-database+unsubscr...@googlegroups.com.
> To post to this group, send email to h2-database@googlegroups.com.
> Visit this group at http://groups.google.com/group/h2-database.
> For more options, visit https://groups.google.com/groups/opt_out.
>

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.