Form a field from two fields in a select - Mailing list pgsql-general

From manuel@des01.sanyres.es
Subject Form a field from two fields in a select
Date
Msg-id slrn9g4eo6.q0r.manuel@des01.sanyres.es
Whole thread Raw
List pgsql-general
Hi.
How can i construct a field from two table fields in
a select clausule.
Something like this:

select (month + " " + year) as date from xxx;

from two fields month and year with they obvious values,
to obtain a string link this:

  102001

and not a number as 2011.

Thank you.

--
Manuel Cano Muñoz
------------------------------
SANYRES, S.A.
Director Dpto. Sistemas
manuel@sanyres.com
manuel@sanyres.es

pgsql-general by date:

Previous
From: Nils Zonneveld
Date:
Subject: Re: SELECT from a table in another database
Next
From: HYip
Date:
Subject: set transaction question