We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
hi: 我下载的PostgreSQL9.3.1-CN-v1.1.pdf,发现pdf中sql的字符串标点均有误。 例如,文档中的8.2节货币类型的sql: SELECT ’12.34’::float8::numeric::money; 此时会出现错误:ERROR: syntax error at or near ".34" 正确的写法应该是: SELECT '12.34'::float8::numeric::money; 看起来好像没什么区别,但sql语句中用的是英文单引号,而文档的sql可能都是中文全角下的单引号。
The text was updated successfully, but these errors were encountered:
这个问题是pdf生成工具的原因,生成的lex-pdf没有对单引号转义,单引号在lex中指右单引号,半角单引号不分左右,最后就变成了全角。 但手工转义也有问题。 \texttt{\char13} 在普通的lex文件上用pdflatex转OK,但在pg的lex-pdf上转pdf就变成了回车了。 \texttt{\char39} 在普通的lex文件上转出来还是全角单引号,在pg的lex-pdf上转pdf确实可以变成半角单引号,但是会多出空格,就是变成下面这样,这样问题也挺大。 SELECT ' 12.34 ' ::float8::numeric::money;
另外,这个问题在官方的英文PDF中也有,好像不太好解决。如果要拷贝SQL执行,还是从html手册上拷吧。
Sorry, something went wrong.
对还有这种语句,要执行都要手动转为英文的单引号。
INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); INSERT INTO cities VALUES ('San Francisco', '(-194.0, 53.0)');
No branches or pull requests
hi:
我下载的PostgreSQL9.3.1-CN-v1.1.pdf,发现pdf中sql的字符串标点均有误。
例如,文档中的8.2节货币类型的sql:
SELECT ’12.34’::float8::numeric::money;
此时会出现错误:ERROR: syntax error at or near ".34"
正确的写法应该是:
SELECT '12.34'::float8::numeric::money;
看起来好像没什么区别,但sql语句中用的是英文单引号,而文档的sql可能都是中文全角下的单引号。
The text was updated successfully, but these errors were encountered: