NAME

SQL::ReservedWords::PostgreSQL - Reserved SQL words by PostgreSQL

SYNOPSIS

   if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) {
       die "$word is a reserved PostgreSQL word!";
   }

   # or

   use SQL::ReservedWords::PostgreSQL 'is_reserved';

   if ( is_reserved( $word ) ) {
       die "$word is a reserved PostgreSQL word!";
   }

DESCRIPTION

Determine if words are reserved by PostgreSQL.

METHODS

is_reserved( $word )

Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3, 7.4, 8.0 or 8.1.

is_reserved_by_postgresql7( $word )

Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3 or 7.4.

is_reserved_by_postgresql8( $word )

Returns a boolean indicating if $word is reserved by either PostgreSQL 8.0 or 8.1.

reserved_by( $word )

Returns a list with PostgreSQL versions that reserves $word.

words

Returns a list with all reserved words.

EXPORTS

Nothing by default. Following subroutines can be exported:

is_reserved

is_reserved_by_postgresql7

is_reserved_by_postgresql8

reserved_by

words

SEE ALSO

http://www.postgresql.org/docs/7.3/static/sql-keywords-appendix.html

http://www.postgresql.org/docs/7.4/static/sql-keywords-appendix.html

http://www.postgresql.org/docs/8.0/static/sql-keywords-appendix.html

http://www.postgresql.org/docs/8.1/static/sql-keywords-appendix.html

AUTHOR

Christian Hansen ch@ngmedia.com

COPYRIGHT

This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.