Connecting Tech Pros Worldwide Forums | Help | Site Map

HOW TO merge two strings

gauravgmbhr's Avatar
Member
 
Join Date: Feb 2007
Posts: 107
#1: Mar 1 '07
can some one plz tell me how to merger two strings in PostgreSQL OR pl/Pgsql

Moderator
 
Join Date: Nov 2006
Location: Boston, USA
Posts: 505
#2: Mar 1 '07

re: HOW TO merge two strings


I think the SQL concatenate operator (two vertical bars) is what you looking for:

Expand|Select|Wrap|Line Numbers
  1. SELECT 'This is my database: ' || version();
  2.  
gauravgmbhr's Avatar
Member
 
Join Date: Feb 2007
Posts: 107
#3: Mar 6 '07

re: HOW TO merge two strings


Quote:

Originally Posted by michaelb

I think the SQL concatenate operator (two vertical bars) is what you looking for:

Expand|Select|Wrap|Line Numbers
  1. SELECT 'This is my database: ' || version();
  2.  


hey thanx for the help
ronverdonk's Avatar
Moderator
 
Join Date: Jul 2006
Location: The Netherlands
Posts: 4,139
#4: Mar 9 '07

re: HOW TO merge two strings


You are double posting (this thread and PHP thread). The PHP thread will be removed.

Ronald :cool:
Reply