Re: collation problem on 9.1-beta1

Peter Eisentraut wrote:
> On ons, 2011-05-11 at 14:58 -0400, Tom Lane wrote:
> > Marc Cousin <cousinmarc@gmail.com> writes:
> > > I've been starting to work on a 'what's new in 9.1' like i did last
> > > year, and am faced with what I feel is a bug, while building a demo case
> > > for collation.
> >
> > > Here it is:
> >
> > > SELECT * from (values ('llegar'),('llorer'),('lugar')) as tmp
> > > order by 1 collate "es_ES.utf8";
> > > ERROR:  collations are not supported by type integer at character 74
> >
> > This isn't a bug, or at least not one we're going to fix.  ORDER BY
> > column-number is a legacy syntax that doesn't support many options, and
> > COLLATE is one of the ones that it doesn't support.

Column numbers in ORDER BY is ANSI syntax so I don't think calling them
"legacy" is accurate.  "limited functionality"?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +