Bug in my ( newbie ) mind?

Greetings,

Please, what am I doing wrong?

chris=# \d phone_prefix
Table "phone_prefix"
-[ RECORD 1 ]----------------------------------------------------------
Attribute | number
Type | integer
Modifier | not null default nextval('"phone_prefix_number_seq"'::text)
-[ RECORD 2 ]----------------------------------------------------------
Attribute | prefix
Type | text
Modifier |

Index: phone_prefix_number_key

chris=# select phone_prefix.prefix order by random() limit 1;
prefix
--------
384
(1 row)

Wonderful, works exactly as expected.

chris=# select lpad((random()*10000)::int, 4, '0')::text as "Number";
Number
--------
2958
(1 row)

ditto

But attempting to concatenate the two is a disaster.

chris=# select phone_prefix.prefix order by random() limit 1 || '-' ||
lpad((random()*10000)::int, 4, '0')::text as "Phone Number";
ERROR: parser: parse error at or near "||"
chris=#

What am i doing wrong?

chris=# select version();
version
------------------------------------------------------------------------
PostgreSQL 7.1beta3 on i586-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

Thanks a 10^6

p.s. imho it would be a terrific help, especially for new-comers to SQL
like me, if the parser could be persuaded to utter just a tiny glimmer of
a hint as to what it thinks one's mistake is instead of the rather
enigmatic "ERROR: parser: parse error at or near".
Is it possible for mere mortals to help?

--
Sincerely etc.,

NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz

-->> Please refrain from using HTML or WORD attachments in e-mails to me
<<--