Re: [sqlite] probably recursive?

On 1 May 2018, at 1:45am, Roman Fleysher wrote: > If x=10 has less than nX dots, all dots with x=10 are deleted. Because of > deletion, y=3 which previously had more than nY dots no longer passes the > threshold and thus y=3 must be deleted too. This could cause

Re: [sqlite] unknown type name 'sqlite_int64'

Hi, On Mon, Apr 30, 2018 at 7:31 PM, jungle Boogie wrote: > On 5:20PM, Mon, Apr 30, 2018 Igor Korot wrote: >> >> Hi, >> >> On Mon, Apr 30, 2018 at 6:30 PM, jungle Boogie > wrote: >> > Hi All, >> > >> > What's happening here?

[sqlite] probably recursive?

Dear SQLiters, I have trouble solving this problem, maybe it is impossible? I have a table with two columns x and y, both integers. Imagine they are coordinates on X-Y plane, dots. I need to find all x's that have more than nX dots, and all y's that have more than nY dots. Both conditions must

Re: [sqlite] unknown type name 'sqlite_int64'

On 5:20PM, Mon, Apr 30, 2018 Igor Korot wrote: > > Hi, > > On Mon, Apr 30, 2018 at 6:30 PM, jungle Boogie wrote: > > Hi All, > > > > What's happening here? > > > > $ cc --version > > OpenBSD clang version 6.0.0 (tags/RELEASE_600/final) (based on LLVM

Re: [sqlite] unknown type name 'sqlite_int64'

Hi, On Mon, Apr 30, 2018 at 6:30 PM, jungle Boogie wrote: > Hi All, > > What's happening here? > > $ cc --version > OpenBSD clang version 6.0.0 (tags/RELEASE_600/final) (based on LLVM 6.0.0) > Target: aarch64-unknown-openbsd6.3 > Thread model: posix > > ARM64 bit on a

[sqlite] unknown type name 'sqlite_int64'

Hi All, What's happening here? $ cc --version OpenBSD clang version 6.0.0 (tags/RELEASE_600/final) (based on LLVM 6.0.0) Target: aarch64-unknown-openbsd6.3 Thread model: posix ARM64 bit on a pine64-lts device running: OpenBSD 6.3-current (GENERIC.MP) #91: Mon Apr 30 01:29:06 MDT 2018