On Mon, December 20, 2010 03:39, Leslie Satenstein wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5795
> Logged by: Leslie Satenstein
> Email address: lsatenstein@yahoo.com
> PostgreSQL version: 8.4+ incl 9.0
> Operating system: Fedora 14 / Debian Squeeze
> Description: 9.0.2 PDF needs editing
>
> Using pdf for 9.0.2 version,
>
> The insert examples in section 2.4 do not function if a cut and paste from
> pdf to psql is done
>
> This is the problem
> INSERT INTO weather VALUES (’San Francisco’, 46, 50, 0.25,
> ’1994-11-27’);
> The fields city and date should have ' as delimiter, not
> ’
> Corrected is the following that works. Error messages are not clear. It
> would be great if psql indicated invalid character as error type.
>
> INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27');
>
see also:
http://archives.postgresql.org/pgsql-docs/2007-12/msg00059.php
That ' to ' conversion (xslt or otherwise) never got implemented.