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