"Joel Fradkin" <[EMAIL PROTECTED]> writes:
> My question is I don’t 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
