[SQL] Concat two fields into one at runtime

[George Handin]

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings