From: Bart Degryse <Bart.Degryse@indicator.be>
To: pgsql-novice@postgresql.org
To: pgsql-sql@postgresql.org
Subject: Re: yet another simple SQL question
Date: Tue, 26 Jun 2007 09:14:17 +0200
Message-ID: <4680D8E8.A3DD.0030.0@indicator.be> (raw)
In-Reply-To: <20070625180717.GA19814@a-kretschmer.de>
References: <467FFEF9.5050603@joshuaneil.com>
<20070625180717.GA19814@a-krets chmer.de>
>>>> "A. Kretschmer" <andreas.kretschmer@schollglas.com> 2007-06-25 20:07 >>>
>am Mon, dem 25.06.2007, um 12:44:25 -0500 mailte Joshua folgendes:
>> Ok,
>>
>> You guys must be getting sick of these newbie questions, but I can't
>> resist since I am learning a lot from these email lists and getting
>> results quick! Thanks to everyone for their contributions.
>>
>> Here is my questions....
>>
>> I have a column that looks like this
>>
>> firstname
>> -----------------
>> John B
>> Mark A
>> Jennifer D
>>
>> Basically I have the first name followed by a middle initial. Is there a
>> quick command I can run to strip the middle initial? Basically, I just
>> need to delete the middle initial so the column would then look like the
>> following:
>>
>> firstname
>> ---------------
>> John
>> Mark
>> Jennifer
>
>Yes, of course:
>
>test=# select split_part('My Name', ' ', 1);
>split_part
>------------
>My
>(1 row)
>
>And now, i think, you should read our fine manual:
>http://www.postgresql.org/docs/current/interactive/
>
>Andreas
While there are several ways to make the split the result will never be good. As someone
responded before: this is multicultural. You can never garantee that the first name stops at the
first space. What about names like Sue Ellen or Pieter Jan. I know people with those names
and none of them would like to be calles Sue or Pieter and right they are. Simply because their
first name doesn't stop at the first space. In many countries the concept of 'middle initials' is
meaningless because no one ever uses it.
In my (humble) opinion there are two roads to walk. Either you get your data from the 'client'
split up to the level of detail you require, if someone knows it's him/her. Or you use the data
as is and you don't split it up.
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Bart.Degryse@indicator.be, pgsql-novice@postgresql.org
Subject: Re: yet another simple SQL question
In-Reply-To: <4680D8E8.A3DD.0030.0@indicator.be>
* 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