Migrating to Python 3 with pleasure

Re:Migrating to Python 3 with pleasure by icedchai on Sunday February 04, 2018 @10:07PM (#16306331)

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

[ Parent | on HN ]

Re:Migrating to Python 3 with pleasure by djrobstep on Sunday February 04, 2018 @11:35PM (#16306616)

As I said:

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

Each row is a mapping with ordered keys.

[ Parent | on HN ]

Re:Migrating to Python 3 with pleasure by icedchai on Monday February 05, 2018 @09:17AM (#16308831)

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.

[ Parent | on HN ]

Re:Migrating to Python 3 with pleasure by djrobstep on Monday February 05, 2018 @05:26PM (#16312818)

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.

[ Parent | on HN ]

Re:Migrating to Python 3 with pleasure by icedchai on Tuesday February 06, 2018 @11:46AM (#16317438)

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

[ Parent | on HN ]