On Oct 23, 2009, at 5:05 AM, Simon Slavin wrote:
> I'm looking for assurance that things work the way I think they do,
> and will continue to do so in future versions.
>
> I'm using a TRIGGER that is triggered AFTER INSERT. The INSERT
> commands do not know or set the value for the ROWID
On 23 Oct 2009, at 3:00am, D. Richard Hipp wrote:
> On Oct 22, 2009, at 9:11 PM, Simon Slavin wrote:
>>
>
>> So now my original query comes down to this: if a column's value is
>> generated by SQLite rather than being supplied by my INSERT command,
>> i.e. if the column has a is INTEGER PRIMARY
On Oct 22, 2009, at 9:11 PM, Simon Slavin wrote:
>
> So now my original query comes down to this: if a column's value is
> generated by SQLite rather than being supplied by my INSERT command,
> i.e. if the column has a is INTEGER PRIMARY KEY, or has a DEFAULT
> value, can I rely on being able to
On 23 Oct 2009, at 1:23am, D. Richard Hipp wrote:
> On Oct 22, 2009, at 7:11 PM, Igor Tandetnik wrote:
>>
>> In SQLite, ROWID _is_ the unique identifier for each record. Any
>> field declared INTEGER PRIMARY KEY is simply an alias for ROWID.
>> "Position in the set", whatever it is, has nothing
On Oct 22, 2009, at 7:11 PM, Igor Tandetnik wrote:
>
> In SQLite, ROWID _is_ the unique identifier for each record. Any
> field declared INTEGER PRIMARY KEY is simply an alias for ROWID.
> "Position in the set", whatever it is, has nothing to do with it.
A clarification:
The ROWID is always
Rich Shepard wrote:
> On Thu, 22 Oct 2009, Simon Slavin wrote:
>
>> I'm using a TRIGGER that is triggered AFTER INSERT. The INSERT
>> commands do not know or set the value for the ROWID column. Can I
>> reliably fetch the value for this column from 'NEW.' ? Or can I
On Thu, 22 Oct 2009, Simon Slavin wrote:
> I'm using a TRIGGER that is triggered AFTER INSERT. The INSERT commands
> do not know or set the value for the ROWID column. Can I reliably fetch
> the value for this column from 'NEW.' ? Or can I rely only on values
> which are explicitly set in the
I'm looking for assurance that things work the way I think they do,
and will continue to do so in future versions.
I'm using a TRIGGER that is triggered AFTER INSERT. The INSERT
commands do not know or set the value for the ROWID column. Can I
reliably fetch the value for this column from
8 matches
Mail list logo