Skip site navigation (1) Skip section navigation (2)

Easy SQL Question

From: "Greg" <greg(at)officium(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Easy SQL Question
Date: 2006-06-12 08:58:22
Message-ID: 000d01c68dfe$5b782d50$126887f0$@co.za (view raw or flat)
Thread:
Lists: pgsql-novice
I Was looking at the PgSQL documentation last night but could not find how
to join two fields as one,

i.e

select (firstname + lastname) as fullname from users

I also tried (Cast(firstname as varchar) + Cast(lastname as varchar))

But that doesn't work..
How do I do this?

Thanks



Responses

pgsql-novice by date

Next:From: Shoaib MirDate: 2006-06-12 09:01:44
Subject: Re: Easy SQL Question
Previous:From: GregDate: 2006-06-12 08:58:04
Subject: Question about stored procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group