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

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