"Joel Fradkin" <jfradkin(at)wazagua(dot)com> writes:
> My question is I dont see an easy way to find an error.
> Typical error text is syntax error at or near "trans" at character 825
> But determining character 825 is a little slow by hand.
PG 8.0 produces more useful output. A trivial example:
regression=# select
regression-# 1/0 as a,
regression-# 1/ as b,
regression-# 1/2 as c;
ERROR: syntax error at or near "as" at character 27
LINE 3: 1/ as b,
^
regression=#
regards, tom lane