Postgres Pro
Downloads
Home   >   mailing lists

combining columns in select - Mailing list pgsql-sql

From Doug Thistlethwaite
Subject combining columns in select
Date
Msg-id 37F62759.84F8E9DB@deltanet.com
Whole thread Raw
Responses Re: [SQL] combining columns in select  (Jens Glaser <jens@helena.jens.de>)
List pgsql-sql
Tree view 
Hello,

I have a table used in a java application that I have been working fine
with ODBC & dbase that I want to move to pgsql.  One of my select
statements is as follows

select lname + ', ' + fname as NAME from table ...

If I try to enter this into psql, I get an error.  This same statement
works fine in the ODBC/dbase.

Why doesn't this work?  Is there a work around so I can get columns of
concatenated text strings?

Thanks,

Doug

pgsql-sql by date:

Previous
From: Sergey Bondarenko
Date:
Subject: plpgsql function arguments
Next
From: Jens Glaser
Date:
Subject: Re: [SQL] combining columns in select