On Wed, 26 Nov 2003, Will Leshner wrote:
>Hi. I'm sorry if this is really basic, but I'm wondering if there is a
>way to query a table based on row number and not rowid. In other words,
>I'd like to be able to ask for row number 13 regardless of what its
>rowid might be. I'm happy to write my own function in C if anybody has
>any suggestions.
I'm really curious. Why?
Unless you're ordering the rows explicitly in the select, the order of the
rows is undefined, and row 13 is not any more significant than row 12, for
example.
And this is definately not portable (if that matters to you.)
>
>Thanks.
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>
--
"The problem with the French is that they don't have a word for entrepreneur"
George W. Bush
----------------------------------------------------------------------
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
