Hacker News new | past | comments | ask | show | jobs | submit login

Unless there is an "order by" clause, the order of rows in the result set is undefined and non-deterministic from query to query.



As I said:

> Not the result set, the rows of the result set.

Each row is a mapping with ordered keys.


Perhaps you are confused and mean "columns"? ("Rows of the result set" is what I was referring to.)

A result set has rows, which are not in a deterministic order unless an "order by" is provided. Each row has columns. The columns are in order, obviously.


Perhaps you are confused and think I'm talking about the ordering of the result set.

I said that database query result rows are made up of ordered dictionaries. I didn't mention ordering of the result set.

Happy to keep repeating this as many times as necessary.


ok. We're actually saying the same thing, just in different words.




Join us for AI Startup School this June 16-17 in San Francisco!

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: