Received: from druid.net (root@druid.net [216.126.72.98]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA39910 for ; Sat, 2 Oct 1999 21:16:57 -0400 (EDT) (envelope-from darcy@druid.net) Received: from localhost (1254 bytes) by druid.net via sendmail with P:stdio/R:bind_hosts/T:inet_zone_bind_smtp (sender: ) (ident using unix) id for ; Sat, 2 Oct 1999 21:15:29 -0400 (EDT) (Smail-3.2.0.104 1998-Nov-20 #4 built 1999-Apr-13) Message-Id: Subject: Re: [SQL] combining columns in select In-Reply-To: from Jens Glaser at "Oct 1, 1999 09:20:31 pm" To: jens@jens.de Date: Sat, 2 Oct 1999 21:15:29 -0400 (EDT) From: "D'Arcy" "J.M." Cain Cc: doug.t@deltanet.com, pgsql-sql@postgreSQL.org Reply-To: pgsql-sql@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL50 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Thus spake Jens Glaser > On Sat, 2 Oct 1999, Doug Thistlethwaite wrote: > > select lname + ', ' + fname as NAME from table ... > > I think this is a parser bug. I recall there is a simple workaround: > > select (lname + ', ') + fname ... (use braces) While you are correct in your solution, it isn't a parser bug. It just follows the spec. There has been talk of allowing the first form as an extension. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.