Re: casting in ORDER BY

Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)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.