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=#