Commit8bb5691

Thomas G. Lockhart

committed

Change ORDER BY to get consistant results with new sorting routines.

1 parentd8ec518 commit8bb5691Copy full SHA for 8bb5691

File tree

-4

lines changed

-4

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -144,5 +144,5 @@ SELECT '' AS two, circle(f1)`
`144`	`144`	`SELECT''AS twentyfour,c1.f1AScircle,p1.f1ASpoint, (p1.f1<->c1.f1)AS distance`
`145`	`145`	`FROM CIRCLE_TBL c1, POINT_TBL p1`
`146`	`146`	`WHERE (p1.f1<->c1.f1)>0`
`147`		`-ORDER BY distance,circle;`
	`147`	`+ORDER BY distance,circle,point using<<;`
`148`	`148`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -21,12 +21,12 @@ SELECT '' AS ten, f1 AS datetime`
`21`	`21`
`22`	`22`	`SELECT''AS hundred,d.f1AS datetime,t.f1AS timespan,d.f1+t.f1AS plus`
`23`	`23`	`FROM TEMP_DATETIME d, TIMESPAN_TBL t`
`24`		`-ORDER BY plus;`
	`24`	`+ORDER BY plus, datetime, timespan;`
`25`	`25`
`26`	`26`	`SELECT''AS hundred,d.f1AS datetime,t.f1AS timespan,d.f1-t.f1AS minus`
`27`	`27`	`FROM TEMP_DATETIME d, TIMESPAN_TBL t`
`28`	`28`	`WHERE isfinite(d.f1)`
`29`		`-ORDER BY minus;`
	`29`	`+ORDER BY minus, datetime, timespan;`
`30`	`30`
`31`	`31`	`SELECT''AS ten,d.f1AS datetime,'1980-01-06 00:00 GMT'::datetimeAS gpstime_zero,`
`32`	`32`	`d.f1-'1980-01-06 00:00 GMT'::datetimeAS difference`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -57,7 +57,7 @@ SET geqo TO 'off';`
`57`	`57`
`58`	`58`	`SELECT''AS thirtysix,p1.f1AS point1,p2.f1AS point2,p1.f1<->p2.f1AS dist`
`59`	`59`	`FROM POINT_TBL p1, POINT_TBL p2`
`60`		`-ORDER BY dist;`
	`60`	`+ORDER BY dist, point1 using<<, point2 using<<;`
`61`	`61`
`62`	`62`	`SELECT''AS thirty,p1.f1AS point1,p2.f1AS point2`
`63`	`63`	`FROM POINT_TBL p1, POINT_TBL p2`

Comments

(0)