|
3 | 3 | * |
4 | 4 | * Copyright (c) 2000-2010, PostgreSQL Global Development Group |
5 | 5 | * |
6 | | - * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.192 2010/01/25 18:23:09 heikki Exp $ |
| 6 | + * $PostgreSQL: pgsql/src/bin/psql/tab-complete.c,v 1.193 2010/02/15 02:55:01 itagaki Exp $ |
7 | 7 | */ |
8 | 8 |
|
9 | 9 | /*---------------------------------------------------------------------- |
@@ -618,7 +618,7 @@ psql_completion(char *text, int start, int end) |
618 | 618 | staticconstchar*constsql_commands[]= { |
619 | 619 | "ABORT","ALTER","ANALYZE","BEGIN","CHECKPOINT","CLOSE","CLUSTER", |
620 | 620 | "COMMENT","COMMIT","COPY","CREATE","DEALLOCATE","DECLARE", |
621 | | -"DELETE FROM","DISCARD","DROP","END","EXECUTE","EXPLAIN","FETCH", |
| 621 | +"DELETE FROM","DISCARD","DO","DROP","END","EXECUTE","EXPLAIN","FETCH", |
622 | 622 | "GRANT","INSERT","LISTEN","LOAD","LOCK","MOVE","NOTIFY","PREPARE", |
623 | 623 | "REASSIGN","REINDEX","RELEASE","RESET","REVOKE","ROLLBACK", |
624 | 624 | "SAVEPOINT","SELECT","SET","SHOW","START","TABLE","TRUNCATE","UNLISTEN", |
@@ -1532,6 +1532,18 @@ psql_completion(char *text, int start, int end) |
1532 | 1532 | COMPLETE_WITH_LIST(list_DISCARD); |
1533 | 1533 | } |
1534 | 1534 |
|
| 1535 | +/* DO */ |
| 1536 | +/* |
| 1537 | + * Complete DO with LANGUAGE. |
| 1538 | + */ |
| 1539 | +elseif (pg_strcasecmp(prev_wd,"DO")==0) |
| 1540 | +{ |
| 1541 | +staticconstchar*constlist_DO[]= |
| 1542 | +{"LANGUAGE",NULL}; |
| 1543 | + |
| 1544 | +COMPLETE_WITH_LIST(list_DO); |
| 1545 | +} |
| 1546 | + |
1535 | 1547 | /* DROP (when not the previous word) */ |
1536 | 1548 | /* DROP AGGREGATE */ |
1537 | 1549 | elseif (pg_strcasecmp(prev3_wd,"DROP")==0&& |
|