--- trunk/bin/pgest-index.pl	2006/08/07 14:30:55	63
+++ trunk/bin/pgest-index.pl	2006/08/07 14:47:00	65
@@ -130,7 +130,7 @@
 
 }
 
-my $cols = "'" . join("','", @cols) . "'";
+my $cols = "'" . join("', '", @cols) . "'";
 
 foreach my $t (qw/UPDATE INSERT DELETE/) {
 
@@ -153,3 +153,23 @@
 }
 
 $dbh->commit;
+
+my $col_names = join(', ', @cols);
+my $col_def = join(', ', map { "$_ text" } @cols);
+
+print "example SQL search query:
+
+
+SELECT $col_names
+FROM pgest(
+	-- node, login, passwd, depth
+	'$c->{node_url}', '$c->{user}', '$c->{passwd}', 0,
+	-- full text search
+	'foo bar',
+	-- attribute filter, order by, limit, offset
+	null, null, null, null,
+	-- return columns
+	array[$cols]
+) as ($col_def);
+
+";