Message-ID: <467FDF28.8000108@joshuaneil.com>
Date: Mon, 25 Jun 2007 10:28:40 -0500
From: Joshua <joshua@joshuaneil.com>
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org, pgsql-novice@postgresql.org,
	pgsql-general@postgresql.org
Subject: another simple SQL question
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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!