From: | Joshua <joshua(at)joshuaneil(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | another simple SQL question |
Date: | 2007-06-25 15:28:40 |
Message-ID: | 467FDF28.8000108@joshuaneil.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-novice pgsql-sql |
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.
THANKS!
From | Date | Subject | |
---|---|---|---|
Next Message | Adrián Ribao Martínez | 2007-06-25 15:36:23 | Move a database from one server to other |
Previous Message | Rich Shepard | 2007-06-25 15:01:25 | Re: simple SQL question |
From | Date | Subject | |
---|---|---|---|
Next Message | Nicholas Barr | 2007-06-25 15:41:02 | Re: another simple SQL question |
Previous Message | Glenn Davy | 2007-06-25 15:02:44 | Re: simple SQL question |
From | Date | Subject | |
---|---|---|---|
Next Message | Ireneusz Pluta | 2007-06-25 15:33:29 | Re: simple SQL question |
Previous Message | Fernando Hevia | 2007-06-25 15:19:49 | Re: simple SQL question |