From: | Glenn Davy <glenn(at)tangelosoftware(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: another simple SQL question |
Date: | 2007-06-25 16:02:46 |
Message-ID: | 200706260202.46681.glenn@tangelosoftware.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice pgsql-sql |
On Tue, 26 Jun 2007 01:28:40 am Joshua wrote:
> Ok here is another simple question from a novice....
>
> Here is what my table looks like
>
> firstname lastname fullname
> ---------- ---------- -----------
> smith, john
> green, susan
> white, jeff
>
>
> How can I break the fullname field into firstname lastname fields so it
> looks like the following:
>
> firstname lastname fullname
> --------- --------- ---------
> john smith smith, john
> susan green green, susan
> jeff white white, jeff
>
> Please let me know. Sorry for such simple novice questions, I appreciate
> your support.
>
update yourtable set firstname= substring(fullname,1,position(',' in
fullname)-1) ,lastname= substring(fullname, position(', ' in fullname)+2,
char_length(fullname));
glenn
> THANKS!
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Derrick Betts | 2007-06-25 16:04:20 | Re: another simple SQL question |
Previous Message | Jason Long | 2007-06-25 16:01:29 | Automatic install on windows |
From | Date | Subject | |
---|---|---|---|
Next Message | Derrick Betts | 2007-06-25 16:04:20 | Re: another simple SQL question |
Previous Message | Daniel T. Staal | 2007-06-25 15:44:20 | Re: another simple SQL question |
From | Date | Subject | |
---|---|---|---|
Next Message | Derrick Betts | 2007-06-25 16:04:20 | Re: another simple SQL question |
Previous Message | Daniel T. Staal | 2007-06-25 15:44:20 | Re: another simple SQL question |