This stuff: /postgresql-8.2.4/src/test/regress/sql Should do for starters. > -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general- > owner@xxxxxxxxxxxxxx] On Behalf Of Kynn Jones > Sent: Friday, July 06, 2007 12:15 PM > To: pgsql-general@xxxxxxxxxxxxxx > 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