Re: Easy SQL Question

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



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings