sql problem

I am trying to have to fields from my postgres db as one.

let's say I have first_name and last_name as fields and I want them to be displayed as "full_name" when showing the results.

How do I put them together ?

(tried things like first_name & " " & last_name etc but didn't seem to work ?

(Postgres 7.1)

PHP-manual:

<?php
/ Assigning a string. /
$str = "This is a string";

/ Appending to it. /
$str = $str . " with some more text";

/ Another way to append, includes an escaped newline. /
$str .= " and a newline at the end.\n";

/ This string will end up being 'Number: 9' /
$num = 9;
$str = "Number: $num";

/ This one will be 'Number: $num' /
$num = 9;
$str = 'Number: $num';

/ Get the first character of a string /
$str = 'This is a test.';
$first = $str{0};

/ Get the last character of a string. /
$str = 'This is still a test.';
$last = $str{strlen($str)-1};
?>

Indeed, however, not what I was looking for.

I want it to come directly from the table, using sql.

select first_name last_name as full_name from table

so that when I pg_fetch_array[full_name] would exist and be composed of first_name and last_name.

So, I want them to be put togehter in sql, not in PHP.

thx anyway

select first||' '||last from person

this works in postgres and oracle even when combining strings and numbers.

try:

select concat(first,' ',last) as fullname from person;

Joe