Received: from spelunker.keyway.net (spelunker.keyway.net [207.155.50.41]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA58019 for ; Sat, 2 Oct 1999 11:40:03 -0400 (EDT) (envelope-from doug.t@deltanet.com) Received: from deltanet.com (b155-49-stat-101.keyway.net [207.155.49.101]) by spelunker.keyway.net (8.9.3/8.9.3) with ESMTP id IAA12165 for ; Sat, 2 Oct 1999 08:39:46 -0700 (PDT) Message-ID: <37F62759.84F8E9DB@deltanet.com> Date: Sat, 02 Oct 1999 08:40:10 -0700 From: Doug Thistlethwaite X-Mailer: Mozilla 4.5 [en]C-CCK-MCD compaq (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql Subject: combining columns in select Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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