Skip site navigation (1) Skip section navigation (2)

RE: Resp: [SQL] Concatenation in selects

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: Fidelis Assis <fidelis(at)embratel(dot)com(dot)br>, owner-pgsql-sql(at)hub(dot)org, pgsql-sql(at)postgreSQL(dot)org
Subject: RE: Resp: [SQL] Concatenation in selects
Date: 1998-09-03 18:45:54
Message-ID: F10BB1FAF801D111829B0060971D839F3E2D33@cpsmail (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
>  select ltrim(first_name) || (' ' || ltrim(last_name)) as full_name
> from
> ...
> where "ltrim" is used only to convert both, first_time and
> last_time, to text. I wish I could convert among string types
> (bpchar, varchar and text) without any tricks, but it seems this
> is not implemented yet.
Ever tried the cast() function?  


pgsql-sql by date

Next:From: Leslie MikesellDate: 1998-09-03 19:33:12
Subject: Re: [SQL] Concatenation in selects
Previous:From: Jackson, DeJuanDate: 1998-09-03 18:29:28
Subject: RE: [SQL] rename table - primary key index?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group