Do you perhaps want this:
select source1,
source2,
(
select min(ts)
from rolling
where source1 = x.source1
and source2 = x.source2
)
from (
select distinct source1,
source2
from rolling
Hi,
I have a database table looking like this:
CREATE TABLE `rolling` (
`source1`TEXT NOT NULL,
`source2`TEXT NOT NULL,
`ts`INTEGER NOT NULL,
`value`TEXT
);
CREATE INDEX `sources` ON `rolling` (
`source1`,
`source2`,
`ts`
);
INSERT INTO rolling
WI
JP wrote:
>
> The answers don't explain why there is a bitness difference at run-time
> between the types retrieved from INT and INTEGER columns, and that's my
> question. From reading https://sqlite.org/datatype3.html I understand
> there should be no difference whatsoever between defining a colu
On 24 Jan 2019, at 3:27pm, JP wrote:
> I have encountered the same problem as this:
> https://stackoverflow.com/q/4925084
What is returned by typeof(reader["myColumn"]) in each case ?
I suspect that you're getting an integer when the column is declared as
INTEGER, but not when the column is d
Hello,
I have encountered the same problem as this: https://stackoverflow.com/q/4925084
The answers don't explain why there is a bitness difference at run-time between
the types retrieved from INT and INTEGER columns, and that's my question. From
reading https://sqlite.org/datatype3.html I unde
5 matches
Mail list logo