On Wed, 17 Dec 2003, ricky(at)babonmultimedia(dot)com wrote:
> 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 name
Use the concatenation operator '||'.
select 'Hello ' || name from user where name = 'John';
You should probably download a copy of the user manual from
<http://www.postgresql.org/docs/> . It describes many of the functions
and operators that are available.
--
Stephen Powell