Re: casting in ORDER BY - Mailing list pgsql-hackers

Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> I try to fix foreign_data regression test for Czech locale (HEAD). For
> example I replaced 
> SELECT * FROM information_schema.user_mapping_options ORDER BY 1, 2, 3,
> 4;
> with following statement:
> SELECT * FROM information_schema.user_mapping_options ORDER BY 1, 2,
> 3::name, 4;

That means something like '3'::name, ie it's a constant.  You'd need
to reference the actual column name.
        regards, tom lane

PS: I'm still of the opinion that it's a bad idea to commit to keeping
all the regression tests independent of whether digits sort before
or after letters.