Re: [firebird-support] question about copyright law

2011-12-15 Thread Mark Rotteveel
On Fri, 16 Dec 2011 06:21:19 +1300, Helen Borrie wrote: >>I disagree: the IPL and IDPL licenses gives every user the right to >>sublicense the work, so they can make a pretty certificate to go with the >>license terms if they want to. > > Whether you agree or disagree, the IPL and IDPL licences r

[firebird-support] Re: table insert into itself - can this be done?

2011-12-15 Thread hvlad
--- In firebird-support@yahoogroups.com, Ann Harrison wrote: > Trust the right side, Luke. Maybe someone has fixed this in a more > recent version of Firebird, but it's a > characteristic bug of databases that Jim Starkey writes. Unless > there's a sort (e.g. order by, distinct, > grouped) they

Re: [firebird-support] question about copyright law - Email found in subject

2011-12-15 Thread Tupy . . . nambá
Sean,   I think the same way as you, but I told that as the only way to have no concerns about this possibility.   And below, Helen Borrie speaks about this concern. Since the concern exists, the possibility exists. And, as one of Murphy´s law say, if it´s very difficult to something happens, th

RE: [firebird-support] question about copyright law - Email found in subject

2011-12-15 Thread Leyne, Sean
Roberto, > The question is that, according to the german culture, there is over and over > the worry about rights. And, still according to the german point of view, > there > is no warranty that later anybody will come and ask for the payment of rights, > still thinking that currently there is no

Re: [firebird-support] question about copyright law

2011-12-15 Thread Helen Borrie
At 11:29 PM 15/12/2011, Mark Rotteveel wrote: >On Thu, 15 Dec 2011 23:25:15 +1300, Helen Borrie >wrote: > >> That was a >> piece of bad advice, not only because it seriously infringes our >trademark >> policy but because it leaves *you* open to criminal prosecution for >false >> pretences. > >I di

RE: [firebird-support] Group by month based on a timestamp?

2011-12-15 Thread Mark Rotteveel
On Thu, 15 Dec 2011 15:28:30 +0100, Svein Erling Tysvær wrote: >>> I've got data in a table containing timestamps in a timestamp column. I >>> want to group these by month. >>> >>> How? >>> >>> Anything simpler/better than this: >>> substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7) >>

RE: [firebird-support] Group by month based on a timestamp?

2011-12-15 Thread Svein Erling Tysvær
>> I've got data in a table containing timestamps in a timestamp column. I >> want to group these by month. >> >> How? >> >> Anything simpler/better than this: >> substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7) > >select > count(*) > , extract(month from mytimestamp) >from > t >

Re: [SPAM 5] Re: [firebird-support] Group by month based on a timestamp?

2011-12-15 Thread Kjell Rilbe
Thomas Steinmaurer skriver: > > > I've got data in a table containing timestamps in a timestamp column. I > > want to group these by month. > > > > How? > > > > Anything simpler/better than this: > > substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7) > > select > count(*) > , extract(mon

Re: [firebird-support] Group by month based on a timestamp?

2011-12-15 Thread Thomas Steinmaurer
> I've got data in a table containing timestamps in a timestamp column. I > want to group these by month. > > How? > > Anything simpler/better than this: > substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7) select count(*) , extract(month from mytimestamp) from t group by ex

[firebird-support] Group by month based on a timestamp?

2011-12-15 Thread Kjell Rilbe
I've got data in a table containing timestamps in a timestamp column. I want to group these by month. How? Anything simpler/better than this: substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7) Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadi

[firebird-support] Group by month based on a timestamp?

2011-12-15 Thread Kjell Rilbe
I've got data in a table containing timestamps in a timestamp column. I want to group these by month. How? Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been re

Re: [firebird-support] question about copyright law

2011-12-15 Thread Mark Rotteveel
On Thu, 15 Dec 2011 23:25:15 +1300, Helen Borrie wrote: > That was a > piece of bad advice, not only because it seriously infringes our trademark > policy but because it leaves *you* open to criminal prosecution for false > pretences. I disagree: the IPL and IDPL licenses gives every user the ri

Re: [firebird-support] question about copyright law

2011-12-15 Thread Helen Borrie
At 10:40 PM 15/12/2011, Tupy... nambá wrote: >still thinking that currently there is no "Vater" or "Mutter" for Firebird >(but, really, Embarcadero now could be thought as the "Grossvater" of this >rights). > Not true. The copyright to the original IB 6.0 beta sources might now be part of Em

Re: [firebird-support] question about copyright law

2011-12-15 Thread Tupy . . . nambá
Olaf,   I understand what you mean and Mark left it very clear about the no existence of this situation with Firebird.   The question is that, according to the german culture, there is over and over the worry about rights. And, still according to the german point of view, there is no warranty th

Re: [firebird-support] question about copyright law

2011-12-15 Thread Mark Rotteveel
On Wed, 14 Dec 2011 20:23:34 +0100, olaf.kl...@satron.de wrote: > On Wed, 14 Dec 2011 19:32:39 +0100, olaf.kl...@satron.de wrote: >> Hello everybody, >> >> one of our customer has no confidence in the Copyright Law of the >> firebird-database. Is there a certificate for confirmation? We need to >>