How to order varchar data by word

From: "Oliveiros C," <oliveiros(dot)cristina(at)marktest(dot)pt>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How to order varchar data by word
Date: 2009-10-14 14:13:22
Message-ID: 99F66F53142145DE8127EAF7423AF726@marktestcr.marktest.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message msi77 2009-10-14 20:41:24 Re: How to get the previous date?
Previous Message ramasubramanian 2009-10-14 10:00:52 Re: How to get the previous date?