George Handin wrote:
Is there a way using built-in PostgreSQL functions to combine two data
fields into a single field at runtime when querying data?
For example, the query now returns:
id first last
--- ------- ----------
1 Goerge Handin
2 Joe Rachin
I'd like it to return:
id name
--- -------------------
1 George Handin
2 Joe Rachin
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
if you want the 2 fields with a space between them
select first ||' '||last as name from foo;
should do it.
Oisin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
