Concat two fields into one at runtime

From: George Handin <postgresql(at)dafunks(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Concat two fields into one at runtime
Date: 2006-06-08 15:50:14
Message-ID: 44884736.3080309@dafunks.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message George Handin 2006-06-08 15:50:42 Re: Query to return modified results at runtime?
Previous Message Richard Broersma Jr 2006-06-08 04:32:36 Re: Query to return modified results at runtime?