Form a field from two fields in a select

From: manuel(at)des01(dot)sanyres(dot)es
To: pgsql-general(at)postgresql(dot)org
Subject: Form a field from two fields in a select
Date: 2001-05-16 09:29:37
Message-ID: slrn9g4eo6.q0r.manuel@des01.sanyres.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sanyres(dot)com
manuel(at)sanyres(dot)es

Responses

Browse pgsql-general by date

  From Date Subject
Next Message manuel 2001-05-16 10:43:48 Re: Which Front End for Postgresql
Previous Message manuel 2001-05-16 09:17:19 Re: Does anyone know?