--- trunk/bin/pgest-index.pl 2006/08/07 17:30:56 69 +++ trunk/bin/pgest-index.pl 2006/08/07 21:08:41 70 @@ -47,9 +47,19 @@ index. Have in mind that you can't use aliases (as I) in this SQL query (or triggers will be created with wrong fields). +If SQL query isn't specified, default one C<< select * from movies >> will +be created. That will be B if all columns are +not needed for search. + =item --pk id -Specify name of primary key column in SQL query. If not specified, C will be used. +Specify name of primary key column in SQL query. If you allready have primary +key on table, and it consists of simgle column (compaund keys are not supported) +it will be picked up automatically. + +If you specify value which is not unique, you will get just last occurence +of that item in index (which might be what you want). That's because specified +C column will be used for C<@uri> in Hyper Estraier. =item --user login @@ -60,7 +70,8 @@ =item --debug -Dump debugging output. It may be specified multiple times for more verbose debugging. +Dump debugging output. It may be specified multiple times for more verbose +debugging. =back @@ -251,6 +262,14 @@ $dbh->commit; +=head1 SEARCHING + +At end of each run, this script will output example search SQL query on STDOUT. + +You can use it to quickly construct queries for your application. + +=cut + my $col_names = join(', ', @cols); my $col_def = join(', ', map { "$_ text" } @cols); @@ -270,3 +289,18 @@ ) as ($col_def); "; + +__END__ + +=head1 AUTHOR + +Dobrica Pavlinusic + +L + +=head1 LICENSE + +This product is licensed under GNU Public License (GPL) v2 or later. + +=cut +