Home > mailing lists

how to concatenate in PostgreSQL - Mailing list pgsql-sql

From	Rehan Saleem
Subject	how to concatenate in PostgreSQL
Date	March 24, 2012 08:44:17
Msg-id	1332589439.54415.YahooMailNeo@web121601.mail.ne1.yahoo.com Whole thread Raw
Responses	Re: how to concatenate in PostgreSQL Re: how to concatenate in PostgreSQL Re: how to concatenate in PostgreSQL
List	pgsql-sql

hi ,

how can we concatinate these lines and execute sql command

set sql = 'select user,username, firstname '

set sql += ' lastname, cardno from table1 where userid=' + 5

exec(sqi)

where 5 is the userid from table1

thanks

From: Tim Landscheidt
Date: 23 March 2012, 19:26:17
Subject: Re: Can I read the data without commit

From: Andreas Kretschmer
Date: 24 March 2012, 08:57:41
Subject: Re: how to concatenate in PostgreSQL