Concat two fields into one at runtime - Mailing list pgsql-sql

Is there a way using built-in PostgreSQL functions to combine two data 
fields into a single field at runtime when querying data?

For example, the query now returns:

id    first    last
---   -------  ----------
1     Goerge   Handin
2     Joe      Rachin

I'd like it to return:

id    name
---   -------------------
1     George Handin
2     Joe Rachin


pgsql-sql by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Query to return modified results at runtime?
Next
From: George Handin
Date:
Subject: Re: Query to return modified results at runtime?