From: | Christopher Sawtell <csawtell(at)xtra(dot)co(dot)nz> |
---|---|
To: | PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Bug in my ( newbie ) mind? |
Date: | 2001-02-21 05:00:13 |
Message-ID: | 01022118001300.05932@berty |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
<<--
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Czeyka | 2001-02-21 05:09:49 | Re: two tables - foreign keys referring to each other... |
Previous Message | Tom Lane | 2001-02-21 04:46:59 | Re: Weird indices |