Hello Everybpdy,
The concatination in select query u can write the query like this.
select c.status||' this '||' is '||' the '||' status ' from course_master as c;
This works fine
Regards
Yogesh
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
"Sandis" <[EMAIL PROTECTED]> writes:
> Ok, i got it, after all! It took > 30 min to write this query. :(
> SELECT textcat(textcat(first_name,text ' '),last_name) from table;
It's a lot easier if you use the SQL-standard concatenation operator:
regression=# select 'foo' || 'bar';
?column?
-
1, 2000 2:48 PM
To: [EMAIL PROTECTED]
Subject: [SQL] Simple concatenation in select query
Hello,
Sorry for the stupid posting, but..
There was a string concatenation function in MySQL:
SELECT CONCAT(first_name, " ", last_name) FROM table;
Is there a similar function in Postgres?
Certain
Hello,
Sorry for the stupid posting, but..
There was a string concatenation function in MySQL:
SELECT CONCAT(first_name, " ", last_name) FROM table;
Is there a similar function in Postgres?
Certainly, it's possible to live without it, but i'd like to write as above,
doing concatenation in place
