BUG #5403: Missing left parenthesis. - Mailing list pgsql-bugs

From Andrey.S.Alexeenko
Subject BUG #5403: Missing left parenthesis.
Date
Msg-id 201004021134.o32BYjsZ086967@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5403: Missing left parenthesis.  (Craig Ringer <craig@postnewspapers.com.au>)
Re: BUG #5403: Missing left parenthesis.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5403
Logged by:          Andrey.S.Alexeenko
Email address:      rastamanchik@mail.ru
PostgreSQL version: 8.4.2
Operating system:   FreeBSD 7.2
Description:        Missing left parenthesis.
Details:

[root@genesis /home/ss25]# psql -U library library
Password for user library:
psql (8.4.2)
Type "help" for help.

library=> SELECT '978-5-699-00691-5'::isbn::text;
ERROR:  malformed record literal: "978-5-699-00691-5"
LINE 1: SELECT '978-5-699-00691-5'::isbn::text;
               ^
DETAIL:  Missing left parenthesis.
library=>
[3]+  Stopped                 psql -U library library
[root@genesis /home/ss25]# psql -U pgsql library
Password for user pgsql:
psql (8.4.2)
Type "help" for help.

library=# SELECT '978-5-699-00691-5'::isbn::text;
     text
---------------
 5-699-00691-5
(1 row)

library=#

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Syslogger tries to write to /dev/null on Windows
Next
From: Craig Ringer
Date:
Subject: Re: BUG #5403: Missing left parenthesis.