On 12/9/2010 6:46 PM, Simon Slavin wrote:
> On 10 Dec 2010, at 12:20am, Ryan Johnson wrote:
>
>> On 12/9/2010 4:56 PM, Igor Tandetnik wrote:
>>> On 12/9/2010 6:42 PM, Ryan Johnson wrote:
create table a(x,y INTEGER);
>>> This creates a table with column x having no affinity, and column y
>>>
On 10 Dec 2010, at 12:20am, Ryan Johnson wrote:
> On 12/9/2010 4:56 PM, Igor Tandetnik wrote:
>> On 12/9/2010 6:42 PM, Ryan Johnson wrote:
>>> create table a(x,y INTEGER);
>> This creates a table with column x having no affinity, and column y
>> having integer affinity. Is this what you meant?
>
On 12/9/2010 7:20 PM, Ryan Johnson wrote:
> In general, is "1"=1 ever true? With all the talk of dynamic typing,
> etc. I would have expected so, but now I wonder...
'1'=1 is of course false. But '1'=x, where x is a column having integer
affinity and value 1, is true.
--
Igor Tandetnik
On 12/9/2010 4:56 PM, Igor Tandetnik wrote:
> On 12/9/2010 6:42 PM, Ryan Johnson wrote:
>> create table a(x,y INTEGER);
> This creates a table with column x having no affinity, and column y
> having integer affinity. Is this what you meant?
Doh! That explains why I couldn't repro with only a
On 12/9/2010 6:42 PM, Ryan Johnson wrote:
> create table a(x,y INTEGER);
This creates a table with column x having no affinity, and column y
having integer affinity. Is this what you meant?
--
Igor Tandetnik
___
sqlite-users mailing list
On 12/9/2010 4:10 PM, Simon Slavin wrote:
> On 9 Dec 2010, at 11:04pm, Ryan Johnson wrote
>> I'm a new user to sqlite (I just compiled sqlite-autoconf-3070400 on
>> ), and am running into what seems to be a bad interaction between
>> type affinity and integer comparisons.
>>
>> I'm importing
On 9 Dec 2010, at 11:04pm, Ryan Johnson wrote:
> I'm a new user to sqlite (I just compiled sqlite-autoconf-3070400 on
> ), and am running into what seems to be a bad interaction between
> type affinity and integer comparisons.
>
> I'm importing a csv file full of single-digit integer
Hi all,
I'm a new user to sqlite (I just compiled sqlite-autoconf-3070400 on
cygwin), and am running into what seems to be a bad interaction between
type affinity and integer comparisons.
I'm importing a csv file full of single-digit integer values into a
table which .schema reports as
8 matches
Mail list logo