Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7BC3DB5DC2E for ; Thu, 23 Jun 2011 04:19:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 42958-09 for ; Thu, 23 Jun 2011 07:18:54 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id F0072B5D944 for ; Thu, 23 Jun 2011 04:18:53 -0300 (ADT) Received: by iyb12 with SMTP id 12so1325508iyb.19 for ; Thu, 23 Jun 2011 00:18:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc:content-type:content-transfer-encoding; bh=963f1xmO4ERgxirartcyOh0wqHnfzTyLXFxdm8gMQCo=; b=SAGF0rLKbmtEZ1XLjoH39Y6wa4wXuLItTQrjeu1KrorZOKDRyiYsP6QesE4rcd0Q2V CzUVVd+WWlFNTCXSfOlU56ai/n5EQq3abSXlOo3x5DNYTLrpxWD7M19yqJjPDSxvbUqb MTL0jGX8hAvxeE0qiSvjONACN9ejt9cHJ1BdU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=ogAkvoJE9BGxjQNBkW86TdNWE1D4ONl+ORjSF+CACW6G/wiFR5ixaK5qpVPu+GiMm3 9NEOF27lDwISIl56M/a9HSNIZInj2cBZi8Ww3zlIIBX0janM2sL3ZnzRLgQeOCYerYXM ErEmfzeHOuwSQwCUYoyBq6AJ3/5Y4+YLXg1C0= Received: by 10.42.243.135 with SMTP id lm7mr1783140icb.267.1308813533128; Thu, 23 Jun 2011 00:18:53 -0700 (PDT) MIME-Version: 1.0 Received: by 10.42.1.141 with HTTP; Thu, 23 Jun 2011 00:18:13 -0700 (PDT) In-Reply-To: <1308805554.22303.0.camel@vanquo.pezone.net> References: <1308773527.10498.7.camel@vanquo.pezone.net> <1308805554.22303.0.camel@vanquo.pezone.net> From: Pavel Stehule Date: Thu, 23 Jun 2011 09:18:13 +0200 Message-ID: Subject: Re: a strange order by behavior To: Peter Eisentraut Cc: Samuel Gendler , Eyal Wilde , pgsql-sql@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.898 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001 X-Spam-Level: X-Archive-Number: 201106/89 X-Sequence-Number: 35555 2011/6/23 Peter Eisentraut : > On tor, 2011-06-23 at 05:57 +0200, Pavel Stehule wrote: >> 2011/6/22 Peter Eisentraut : >> > On ons, 2011-06-22 at 02:39 -0700, Samuel Gendler wrote: >> >> Pavel suggested using a collation of ucs_basic, but I get an error >> >> when I >> >> try that on linux: >> >> >> >> $ createdb -U u1 --lc-collate=3Ducs_basic -E UTF-8 test >> >> createdb: database creation failed: ERROR: =C2=A0invalid locale name = ucs_basic >> > >> > ucs_basic is a collation name, which is an SQL object. =C2=A0The argum= ent of >> > createdb --lc-collate is an operating system locale name. =C2=A0You ca= n't mix >> > the two, even though they are similar. >> > >> >> ok, what I can to select, when I would to use a C like default order? > > createdb --locale=3DC --encoding=3DUTF8 > ok, thank you Pavel > >