Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D34FD633AB9 for ; Wed, 14 Oct 2009 11:13:34 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84056-03 for ; Wed, 14 Oct 2009 14:13:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from jupiter.marktest.pt (delta.marktest.pt [80.251.174.116]) by mail.postgresql.org (Postfix) with ESMTP id EC1FF6339AB for ; Wed, 14 Oct 2009 11:13:26 -0300 (ADT) Received: from Proteu (proteu.marktest.pt [10.61.90.54]) by jupiter.marktest.pt with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 4R8TJC85; Wed, 14 Oct 2009 15:13:23 +0100 Message-ID: <99F66F53142145DE8127EAF7423AF726@marktestcr.marktest.pt> From: "Oliveiros C," To: References: <6caee9520910140240u13daba93ua20637642727776e@mail.gmail.com> Subject: How to order varchar data by word Date: Wed, 14 Oct 2009 15:13:22 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002E_01CA4CE0.DED5A890" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.5512 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200910/58 X-Sequence-Number: 33257 This is a multi-part message in MIME format. ------=_NextPart_000_002E_01CA4CE0.DED5A890 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, list. I have a table with a varchar field that I would like to order by word, = not by ordinal, which seems to be the default on postgres. Does anyone have a clue on how this can be done? Many thanx in advance, Best, Oliveiros ------=_NextPart_000_002E_01CA4CE0.DED5A890 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello, list.

I have a table with a varchar field = that I would=20 like to order by word, not by ordinal, which seems to be the default on=20 postgres.

Does anyone have a clue on how this can = be=20 done?

Many thanx in advance,

Best,

Oliveiros

------=_NextPart_000_002E_01CA4CE0.DED5A890--