SQL question

From: Travis Bauer <trbauer(at)indiana(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: SQL question
Date: 2000-07-10 10:37:09
Message-ID: Pine.GSO.4.21.0007100535040.11005-100000@mantaray.cs.indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ???? ?

----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert D. Nelson 2000-07-10 12:24:00 RE: PostgreSQL & the BSD License
Previous Message Gabriel López Millán 2000-07-10 10:33:51 JDBC and LOB