pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Henrik Steffen <henrik@steffen.stade.net>
To: pgsql-sql@postgresql.org
Subject: TRANSLATE()
Date: Sat, 08 May 1999 18:58:43 +0200
Message-ID: <37346D43.419B4AFA@steffen.stade.net> (raw)

Hello all,

I wonder how I can translate some German special characters for an ORDER
BY clause.

say, you got some German words like these:

Abend
Ära
Opa
Österreich
Übergabe
Ufer

and want to order them in the way above, you will need to translate 'Ä'
into 'Ae', 'Ö' into 'Oe' and 'Ü' into 'Ue' to order them correctly.

I thought of something like this:
SELECT myword FROM words ORDER BY TRANSLATE(myword,'Ä','Ae');

But now I only got one of the cases. How can I combine all the three
translations?

Any help appreciated!


Greetings

Henrik Steffen
http://www.AH-Tuning.de





view thread (2+ messages)  latest in thread

Message-ID: <37346D43.419B4AFA@steffen.stade.net>
Permalink:  ../37346D43.419B4AFA@steffen.stade.net/
Also on:    postgresql.org/message-id/37346D43.419B4AFA@steffen.stade.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: henrik@steffen.stade.net
  Subject: Re: TRANSLATE()
  In-Reply-To: <37346D43.419B4AFA@steffen.stade.net>
  References: <37346D43.419B4AFA@steffen.stade.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox