Thread: Re: add some word in select

Re: add some word in select

From
"Ricky"
Date:
hello, i have sql "select name from user" then row result "John" come up. is
it posible that the result produce
"HELLO John"  . there's word "Hello" before the row name

thanks
RIcky

Re: add some word in select

From
"Ropel"
Date:
If I've understood what you mean, the answer is:
"select 'Hello ' || name from user"

( || is  pipe character two times )

Bye

Roberto

----- Original Message -----
From: "Ricky" <ricky@babonmultimedia.com>
To: <pgsql-odbc@postgresql.org>
Sent: Thursday, December 18, 2003 11:44 AM
Subject: Re: [ODBC] add some word in select


> hello, i have sql "select name from user" then row result "John" come up.
is
> it posible that the result produce
> "HELLO John"  . there's word "Hello" before the row name
>
> thanks
> RIcky
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend