select id, first || ' ' || last
from mytable;

On 6/8/06, George Handin <[EMAIL PROTECTED]> 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


Reply via email to