Re: SQL question - Mailing list pgsql-general

From NRonayette
Subject Re: SQL question
Date
Msg-id 3969C13F.68F1506E@socotec.fr
Whole thread Raw
In response to SQL question  (Travis Bauer <trbauer@indiana.edu>)
List pgsql-general

Travis Bauer a écrit :
>
> Is it possible to return a column in an sql statement which concantenates
> two other columns and adds some other characters.  For example:
>
> create table t1 (x int, y int);
> insert into t1 values(1,2);
> select ???? as nifty from t1;
>
> nifty
> -----
> 1/2
>
> What should I put in for the ???? ?

select t1.x||'/'||t1.y from t1;

this should work. If you can't concatenate int with char (t1.x with
'/'), you must use a function to convert int in char If "to_char" is the
name of this function, ???? became : to_char(t1.x)||'/'||to_char(t1.y)

Nicolas

pgsql-general by date:

Previous
From: Travis Bauer
Date:
Subject: SQL question
Next
From: "Robert D. Nelson"
Date:
Subject: RE: PostgreSQL & the BSD License