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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I Was looking at the PgSQL documentation last night but could not find how
to join two fields as one,


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?



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-2017 The PostgreSQL Global Development Group