Stephen Frost wrote: -- Start of PGP signed section. > * Kynn Jones (kynnjo@xxxxxxxxx) wrote: > > 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.) > > Two things, one, couldn't you just make the lexer/parser in PG into a > C library and then write bindings for it for use under Perl? Seems like > that'd be more sane. Second, PG's got a regression test suite that > would probably work decently for testing your lexer/parser. You might > have to filter out '\' commands, if there are any, and things like that. Ditto. Also consider that the grammer changes in every major PostgreSQL release. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +