Concatenation in selects - Mailing list pgsql-sql

From James Olin Oden
Subject Concatenation in selects
Date
Msg-id 81Sep2.081317edt.35713@gateway.lee.k12.nc.us
Whole thread Raw
Responses Resp: [SQL] Concatenation in selects  ("Fidelis Assis" <fidelis@embratel.com.br> (Tel +55 21 519 8408))
List pgsql-sql
I know it can be done, but I cannot seem to figure out how to output to
fields concatenated together in a select.  For instance, I have a table
with first_name and last_name as fields (among others).  I would like
display first_name and last_name as one field.  I want to do something
like:

   name=first_name + " " + last_name

but of course within an SQL select statement.  Thanks...james





pgsql-sql by date:

Previous
From: Ronnie Doggart
Date:
Subject: Forming Query
Next
From: James Olin Oden
Date:
Subject: Re: [SQL] Concatenation in selects