This stuff:
/postgresql-8.2.4/src/test/regress/sql
Should do for starters.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Kynn Jones
> Sent: Friday, July 06, 2007 12:15 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] ISO TESTS for a Pg lexer+parser
>
> Hi! I am in the process of writing a PostgreSQL lexer/parser in Perl,
> because everything else I've found in this area is too buggy. I'm
> basing this lexer/parser on the lexer and parser encoded respectively
> in scan.l and gram.y under src/backend/parser.
>
> I'm looking for a solid collection of test cases to test my
> lexer/parser. (I'm hoping that such a collection has already been
> produced to test the PostgreSQL yacc-generated parser that comes with
> the PostgreSQL distribution.)
>
> (Alternatively, if a non-flaky, rock-solid, and easily customizable Pg
> parser in Perl already exists please let me know.)
>
> TIA!
>
> kj
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: explain analyze is your friend