[postgis-devel] Small regression test updates

[Andreas 'ads' Scherbaum]

Hi,

Am 20.07.2011 08:23, schrieb Sandro Santilli:
> On Tue, Jul 19, 2011 at 10:25:29PM +0200, Andreas 'ads' Scherbaum wrote:
>
>> Attached you can find a small patch which adds "order by 1" in some
>> of the regression tests, and also changes the output order in some
>> of the .expected files. The data itself is not changed. The patch
>> works with PostgreSQL 9.04 and PostGIS 1.5.3.
>
> Wouldn't it be safer, at that point, to order by a real column ?

The SQL standard allows numbers for the columns.
Plus then you end up with a sql like:


order by "<function name>"



Here is a description from the SQL92 standard:



          13.5  <select statement: single row>

          Function

          Retrieve values from a specified row of a table.

          Format

          <select statement: single row> ::=
               SELECT [ <set quantifier> ] <select list>
                 INTO <select target list>
                   <table expression>

          <select target list> ::=
               <target specification> [ { <comma> <target specification> 
}... ]



          Syntax Rules

          1) The number of elements in the <select list> shall be the
             same as the number of elements in the <select target list>.
             The i-th <target specification> in the <select target list>
             corresponds with the i-th element of the <select list>.



Life's easier, if you don't have to care about the column names.


Regards,

-- 
				Andreas 'ads' Scherbaum
German PostgreSQL User Group
European PostgreSQL User Group - Board of Directors
Volunteer Regional Contact, Germany - PostgreSQL Project