> Sorry, didn't mean to imply it wouldn't. You added this caveat though:
>
> > Note however that this really only does what you want when
> tableB is initially empty
Yeah, that's fairly easy to work around though. Assuming you know
the structure of the ultimate destination table, which
>
>Out of curiosity, why doesn't the idea I proposed work? If there's a
> situation where it doesn't work I'd like to know, so I don't try using
> it myself should a similar situation arise. :)
Sorry, didn't mean to imply it wouldn't. You added this caveat though:
> Note however that this
Thursday, May 19, 2005 11:52 AM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] How to get row numbers in a query?
>
> So I guess I have to write my own function, "current_row()", using the
> sqlite3_create_function() APIs?
>
> -Dave
>
> -Original Me
> So I guess I have to write my own function, "current_row()", using the
> sqlite3_create_function() APIs?
If you've got a program handling this why don't you just count them as you
retrieve them?
So I guess I have to write my own function, "current_row()", using the
sqlite3_create_function() APIs?
-Dave
-Original Message-
From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 8:40 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to get r
>
>Are you sure this is true? The rowid in the source table has no
> relationship to the order of the results of the query.
You're right. I thought it was the row number of the result set, it's not:
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
> Is there any way to SELECT out the row number of returned results in a
> query?
> For example:
>
> SELECT row_number(), value from some_table;
> 1 ValueA
> 2 ValueB
> 3 ValueC
> ... etc ... ??
>
> What I really want this for is a query where I am inserting from table A
> into table B, and
for if
there are already rows in tableB. This is a fairly easy problem to
solve using intermediate tables though.
-Tom
> -Original Message-
> From: Brown, Dave [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 19, 2005 1:53 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite]
Brown, Dave wrote:
Is there any way to SELECT out the row number of returned results in a
[...]
I want this to result in the following being added to tableB:
Value | Ordering
5 1
8 2
9 3
etc
Any ideas?
-Dave
I think you should register a new functions
Is there any way to SELECT out the row number of returned results in a
query?
For example:
SELECT row_number(), value from some_table;
1 ValueA
2 ValueB
3 ValueC
... etc ... ??
What I really want this for is a query where I am inserting from table A
into table B, and table B has a column
10 matches
Mail list logo