Robert Haas wrote:
> On Thu, Jun 9, 2011 at 2:19 PM, Peter Eisentraut wrote:
> > On tor, 2011-06-09 at 13:30 -0400, Bruce Momjian wrote:
> >> Column numbers in ORDER BY is ANSI syntax so I don't think calling
> >> them "legacy" is accurate. ?"limited functionality"?
> >
> > It was in SQL 92, but r
On Thu, Jun 9, 2011 at 2:19 PM, Peter Eisentraut wrote:
> On tor, 2011-06-09 at 13:30 -0400, Bruce Momjian wrote:
>> Column numbers in ORDER BY is ANSI syntax so I don't think calling
>> them "legacy" is accurate. "limited functionality"?
>
> It was in SQL 92, but removed in 99, so it's technical
On tor, 2011-06-09 at 13:30 -0400, Bruce Momjian wrote:
> Column numbers in ORDER BY is ANSI syntax so I don't think calling
> them "legacy" is accurate. "limited functionality"?
It was in SQL 92, but removed in 99, so it's technically no longer part
of the standard.
--
Sent via pgsql-bugs mai
Peter Eisentraut wrote:
> On ons, 2011-05-11 at 14:58 -0400, Tom Lane wrote:
> > Marc Cousin 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:
On 02/06/2011 14:09, Peter Eisentraut wrote:
On ons, 2011-05-11 at 14:58 -0400, Tom Lane wrote:
Marc Cousin 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:
SELE
On ons, 2011-05-11 at 14:58 -0400, Tom Lane wrote:
> Marc Cousin 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'
Marc Cousin 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";
Hi,
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 s
