Commita01f6fa

committed

psql: Tab completion for JOIN ... ON/USING

Offer ON/USING clauses for join types that require join conditions (i.e.anything except for NATURAL/CROSS joins).Author: Andreas KarlssonReviewed-By: Tomas VondraDiscussion:https://postgr.es/m/3a7e27bc-d6ed-4cb0-9b21-f21143fc1b37@proxel.se

1 parent5dd5786 commita01f6faCopy full SHA for a01f6fa

File tree

+12

-0

lines changed

+12

-0

lines changed

Lines changed: 12 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -5167,6 +5167,18 @@ match_previous_words(int pattern_id,`
`5167`	`5167`	`/* ... JOIN ... */`
`5168`	`5168`	`elseif (TailMatches("JOIN"))`
`5169`	`5169`	`COMPLETE_WITH_SCHEMA_QUERY_PLUS(Query_for_list_of_selectables,"LATERAL");`
	`5170`	`+elseif (TailMatches("JOIN",MatchAny)&& !TailMatches("CROSS\|NATURAL","JOIN",MatchAny))`
	`5171`	`+COMPLETE_WITH("ON","USING (");`
	`5172`	`+elseif (TailMatches("JOIN",MatchAny,MatchAny)&&`
	`5173`	`+ !TailMatches("CROSS\|NATURAL","JOIN",MatchAny,MatchAny)&& !TailMatches("ON\|USING"))`
	`5174`	`+COMPLETE_WITH("ON","USING (");`
	`5175`	`+elseif (TailMatches("JOIN","LATERAL",MatchAny,MatchAny)&&`
	`5176`	`+ !TailMatches("CROSS\|NATURAL","JOIN","LATERAL",MatchAny,MatchAny)&& !TailMatches("ON\|USING"))`
	`5177`	`+COMPLETE_WITH("ON","USING (");`
	`5178`	`+elseif (TailMatches("JOIN",MatchAny,"USING")\|\|`
	`5179`	`+TailMatches("JOIN",MatchAny,MatchAny,"USING")\|\|`
	`5180`	`+TailMatches("JOIN","LATERAL",MatchAny,MatchAny,"USING"))`
	`5181`	`+COMPLETE_WITH("(");`
`5170`	`5182`
`5171`	`5183`	`/* ... AT [ LOCAL \| TIME ZONE ] ... */`
`5172`	`5184`	`elseif (TailMatches("AT"))`

Comments

(0)