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?
-
PostgreSQL has a string concatenation operator (see operators in the
manual):
SELECT last_name||', '||first_name FROM ...
Here's a ref: http://www.postgresql.org/docs/user/x2129.htm
Henry
-Original Message-
From: Sandis [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 2:48 PM
To
