George Handin wrote:
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
select id,first||' '||last from your_table
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
