Re: editors with colum positioning for debugging? - Mailing list pgsql-sql

"Joel Fradkin" <jfradkin@wazagua.com> 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