| Search.setIndex({docnames:["advanced/advanced","advanced/advanced_overview","advanced/plpgsql","advanced/prepared_statements","advanced/sql_in_cypher","clauses/create","clauses/delete","clauses/limit","clauses/match","clauses/merge","clauses/order_by","clauses/remove","clauses/return","clauses/set","clauses/skip","clauses/with","contributing/run_tests","functions/aggregate_functions","functions/list_functions","functions/logarithmic_functions","functions/numeric_functions","functions/predicate_functions","functions/scalar_functions","functions/string_functions","functions/trigonometric_functions","functions/user_functions","index","intro/aggregation","intro/agload","intro/comparability","intro/cypher","intro/graphs","intro/operators","intro/overview","intro/precedence","intro/setup","intro/types"],envversion:{"sphinx.domains.c":2,"sphinx.domains.changeset":1,"sphinx.domains.citation":1,"sphinx.domains.cpp":4,"sphinx.domains.index":1,"sphinx.domains.javascript":2,"sphinx.domains.math":2,"sphinx.domains.python":3,"sphinx.domains.rst":2,"sphinx.domains.std":2,sphinx:56},filenames:["advanced/advanced.md","advanced/advanced_overview.md","advanced/plpgsql.md","advanced/prepared_statements.md","advanced/sql_in_cypher.md","clauses/create.md","clauses/delete.md","clauses/limit.md","clauses/match.md","clauses/merge.md","clauses/order_by.md","clauses/remove.md","clauses/return.md","clauses/set.md","clauses/skip.md","clauses/with.md","contributing/run_tests.md","functions/aggregate_functions.md","functions/list_functions.md","functions/logarithmic_functions.md","functions/numeric_functions.md","functions/predicate_functions.md","functions/scalar_functions.md","functions/string_functions.md","functions/trigonometric_functions.md","functions/user_functions.md","index.rst","intro/aggregation.md","intro/agload.md","intro/comparability.md","intro/cypher.md","intro/graphs.md","intro/operators.md","intro/overview.md","intro/precedence.md","intro/setup.md","intro/types.md"],objects:{},objnames:{},objtypes:{},terms:{"0":[5,6,8,9,12,13,17,18,19,20,22,23,24,29,32,36],"036":36,"0471975511965979":24,"0700":16,"0750":16,"0to":17,"1":[0,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,22,23,24,25,27,29,32,34,36],"10":[9,18,19,28,32,33,34,36],"1000":36,"11":[18,22,23,32,34,35],"1125899906842625":12,"1125899906842640":18,"1125899906842644":18,"113":11,"12":[17,19,27,32,34],"1234567890":0,"13":[17,27],"14":18,"1407374883553281":[12,27],"1407374883553282":27,"1407374883553283":27,"14159":24,"141592":20,"14159265358979":24,"141592653589793":24,"144":19,"15":[17,36],"16":36,"1613496720760":22,"17":[18,20],"170":10,"179":24,"18":18,"180":24,"185":10,"1970":22,"1return":15,"2":[0,5,7,8,12,14,15,17,18,19,21,22,23,27,32,34,36],"2021":4,"2123e1af756543542064ae0d07792be90176b311b":17,"223":36,"23":[17,36],"25":[0,18,22,25],"27":19,"281474976710659":[6,12],"281474976710660":12,"281474976710661":13,"29":17,"295836866004329":19,"3":[0,5,7,8,10,11,13,14,15,17,18,19,20,22,23,24,27,30,32,34,36],"30":[12,17],"32":10,"33":[17,27],"34":10,"35":0,"3586784748902053":20,"36":[0,13],"372":36,"38":[18,20,22],"38905609893065":19,"4":[2,8,17,18,22,32,34,36],"40th":17,"41":[18,20],"42":22,"4313637641589874":19,"44":[17,27],"463647609000806":24,"479425538604203":24,"5":[8,17,18,22,23,24,32,34,36],"50":0,"50th":17,"5141":36,"523598775598299":24,"53":[18,22],"54":18,"5463024898437905":24,"55":12,"6":[8,18,22,24,27,32,34,36],"64":36,"694738276196703":24,"7":[8,18,19,22,32,34,36],"716233645501712":17,"71828182845905":19,"754":36,"775":36,"8":[16,18,27,32,34,36],"807":36,"808":36,"832251036613439":17,"844424930131988":18,"844424930131989":18,"844424930131992":18,"854":36,"8775825618903728":24,"9":[18,32,34,36],"90":17,"99984796050427":24,"boolean":[21,22,23,29,31,36],"byte":36,"case":[17,34,36],"char":36,"class":28,"default":[25,30,32,36],"do":[3,10,13,25,27,28,35,36],"export":16,"final":36,"float":[17,19,20,22,23,24,29],"function":[3,5,6,11,12,13,29,30,31,32,33,34,35],"import":[26,36],"long":[7,8,22],"new":[5,9,10],"null":[11,12,13,18,19,20,22,23,24,27,29,30,32,34],"public":[4,35],"return":[0,2,3,4,8,9,10,11,15,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,36],"switch":15,"true":[0,12,13,21,22,23,28,29,31,36],"try":17,"void":[4,31],"while":36,A:[0,3,5,6,7,8,9,10,11,12,13,15,17,18,20,21,22,23,24,27,28,30,33,35,36],AND:[0,5,18,20,32,34],AS:[0,2,3,4,10,15,30,32,36],AT:28,As:9,BE:28,BY:[0,7,14,15,26,27,29],But:29,By:[8,9,10,14,28,32],For:[6,9,17,27,29,32,34,36],IN:[29,32,34],IS:[32,34],If:[8,9,10,12,13,20,22,23,24,27,30,31,35,36],In:[6,10,12,17,26,27,29,35,36],It:[2,8,9,12,17,27,29,31,36],NOT:[32,34],No:2,Not:[30,36],ON:[0,35],OR:[2,4,32,34],On:36,One:[0,13],TO:[2,17,28,35],The:[0,3,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,22,23,24,26,27,29,31,33,35,36],Then:36,There:0,These:[27,36],To:[5,6,7,8,12,13,14,17,27,31,36],WITH:[0,8,10,26,27,29,32,34,36],_:36,_note:36,a_bool:22,a_float:22,aa:29,abl:[15,36],about:[30,36],abov:27,absolut:20,accept:[7,14],access:[32,34],accomplish:9,accord:35,acronym:33,act:[8,32],acted_in:[2,8],activ:17,actor:[2,8,9],actors_nam:8,actual:[17,36],ad:[10,25,28,32,35],add:[6,8,25,35],addit:[32,34,36],adefault:18,advanc:[1,30],affect:0,after:[8,10,32,35],ag:[0,2,3,4,6,7,9,10,11,12,13,14,16,17,18,20,22,25,28,29,32,33,34,36],ag_catalog:[2,17,25,28,30,31,35],again:[15,36],against:16,age_load:28,agensgraph:33,ages_match:0,aggr:27,aggreg:[10,26],agload_test_graph:28,agtyp:[0,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,28,30,32],akin:36,alert:36,algorithm:8,alia:15,alias:15,alic:[18,20,22],alice_ag:20,align:29,all:[1,5,9,15,17,18,22,23,24,25,27,28,29,36],alloc:36,allow:[0,8,10,11,27,29,30,36],along:33,alphabet:12,alphanumer:3,alreadi:[5,9,10,21,22,29],also:[6,8,10,11,15,29,36],alter:10,alter_ego:2,altern:[27,29,36],alwai:[8,10,17,18,29,36],american:8,amount:36,an:[0,3,6,8,9,10,15,16,17,18,19,20,21,22,23,24,26,27,28,29,31,32,33,34],an_integ:22,analog:27,analysi:28,ander:15,andr:[0,5,6,11,13],andrew:8,angl:24,ani:[0,5,7,8,9,12,14,15,17,18,20,23,27,29,31,32,36],annot:36,anoth:[5,6,11,13,23,27,36],ansi:33,anylist:17,anystr:17,anyth:36,apach:[4,16,33],appear:[17,36],appli:[8,35],applic:27,approxim:[20,36],apt:35,ar:[0,4,5,8,9,10,12,14,15,17,18,20,21,22,27,28,29,30,31,32,36],arbitrari:[3,29],arc_c:24,arc_t2:24,arc_t:24,arccosin:24,arcsin:24,arctang:24,arctangent2:24,argument:[3,17,18,19,20,21,22,23,24,30,31,35],arithmet:18,around:[23,36],arrai:[18,22,29],ascend:[10,17,29],assign:[5,29,36],associ:[8,36],assum:[17,27,35],attempt:[35,36],attribut:36,auto:17,automat:[28,31,36],avail:[8,10],averag:[17,27],avg:27,avg_ag:17,aw:28,awai:36,b:[5,7,9,10,12,14,17,18,22,27,28,29,36],back:36,backslash:36,backspac:36,balanc:36,base:[15,19,23,29],basic:[31,36],becaus:[27,36],been:[6,8,12,23,28,29,31],befor:[8,10,25,27,28,29],begin:[2,8,23,32],behav:0,behavior:[9,36],being:[4,17,27,29,36],belong:[8,30],below:[5,27,29,32,34,35,36],berlin:22,best:36,between:[8,17,18,22,28,31,36],big:29,bigint:36,bil:32,bill:32,bin:35,bind:[8,15],bison:35,bit:36,bitnin:33,block:12,blue:[17,18,22,27],bob:[18,22],bodi:2,bool:29,bool_kei:36,bool_to_str:23,boolean_result:36,bornin:9,bossman:15,both:[8,17,23,29,33,36],bound:[8,18,36],boundari:36,bracket:36,branch:[28,36],brown:[17,18,22,27],bucket:27,bud:8,build:35,c:[7,9,10,14,17,18,22,24,27],calcul:[17,27,36],call:[1,3,4,5,6,11,12,13,25,30,32,34,35,36],can:[0,1,2,3,4,5,6,8,9,10,12,15,16,17,27,28,29,30,31,32,33,35,36],candid:27,cannot:[0,6,10,36],cardin:10,carefulli:36,carl:8,carriag:36,cascad:31,cast:29,categori:36,caus:36,ceasar:15,certain:[9,15,36],chang:[10,12,13,29],charact:[23,29,32,36],charli:[8,9,18,22],check:[16,28,32,34],choic:36,cil:20,citi:[22,28],city2:28,clarifi:17,classifi:36,claus:[1,3,8,9,10,14,15,21,27,29,36],click:27,clone:16,clone_path:16,close:[24,36],co_actor:8,code:[16,28,36],coerc:[29,36],coercion:36,col_1:0,col_2:0,col_3:0,collect:6,colon:8,color:22,column:[0,5,6,11,12,13,27,28,29,30,36],com:35,combin:[9,17,27],come:[10,13],comma:[5,13,36],command:[2,4,13,16,17,31,35,36],common:[0,12,19,35,36],commonli:21,compar:[17,26,27,36],comparison:[0,10,29],complex:[1,29],complic:36,compon:36,compris:18,comput:[27,36],con:4,concept:36,conceptu:[29,36],concern:36,condit:30,configur:16,conform:36,conjunct:27,connect:[8,15,17,31,36],consecut:18,consequ:29,consid:[8,17,27,29,36],consider:[17,18,19,20,22,23,24,30,31],consist:[2,29,31],constant:[18,24,36],constrain:[7,8],constraint:9,construct:[30,36],contain:[9,12,17,18,22,23,28,29,34,36],context:[29,36],convers:36,convert:[22,23,24,36],coordin:24,correct:9,correctli:36,cosin:24,could:27,count:[15,27,28,36],countri:28,country2:28,coupl:8,creat:[0,2,3,9,16,17,18,22,26,27,32,33,35,36],create_elabel:28,create_graph:[17,28],create_vlabel:28,creation:[2,28],critic:9,cte:26,current:[4,8,22,28,29],custom:[25,36],cypher:[1,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,27,28,29,32,35,36],cypher_prepared_stat:3,cypher_stored_procedur:3,d1:[17,27],d2:[17,27],d:[9,14,17,18,27],dafo:2,daniel:18,data:[2,5,6,8,11,13,16,26,28,29,31,33],databas:[8,33],david:15,db_user:35,ddl:31,debian:16,decim:[29,36],declar:[2,8,36],deduc:36,defin:[4,5,6,11,12,13,14,18,26,29,30,36],definit:[5,6,11,12,13,30],defo:[8,21],deg:24,delet:26,delimit:23,denomin:17,denot:[23,36],depend:[10,12,17,18,27,31,35],desc:[10,15],descend:15,describ:[8,36],descript:[8,17,18,19,20,21,22,23,24,28,30,31,36],design:[8,36],desir:[16,17],detach:6,detail:[3,16,27,28,36],determin:29,dev:35,devel:35,develop:[0,2,4,5,13,22],deviat:[17,29],dialog:16,dictionari:[17,29],did:36,differ:[12,18,20,21,22,27,28,36],differencebetween:18,digit:36,direct:[31,36],directli:4,director:8,directori:[16,35],discrep:36,discuss:36,disk:36,distinct:[10,12,17,29,36],distinct_ey:27,distribut:20,divid:27,divis:[32,34],dml:31,dnf:35,doc:35,doctor:0,document:[28,35],doe:[4,8,9,10,30,36],doesn:11,don:[16,29],done:[5,8,10,11,13,15,27,35],dot:12,doubl:36,dougla:[8,9],downei:2,dpkg:16,drop:31,drop_graph:28,duplic:27,dure:[8,22],e:[4,5,9,14,17,18,20,22,27,28,29,36],each:[8,10,27,29,31,35,36],edg:[11,13,18,21,22,28,29,31],edge_label:36,eight:36,either:[6,8,9,10,15,23,27],element:[6,8,17,18,22,29,32,34],ell:23,els:[12,31],emil:15,empti:[23,36],en_u:16,enabl:28,enclos:12,encod:36,end:[2,5,6,10,11,13,17,18,22,23,28,29,34,36],end_id:[12,18,28,36],end_vertex_typ:28,endid:[5,12,36],english:12,ensur:[2,9],entir:[17,22,36],entiti:[18,29],entri:[15,29],environ:[16,35],equal:[10,20,26,36],equival:[8,26,27],error:[3,23,27,30,31,36],escap:36,eskil:[18,20,22],eskil_ag:20,especi:36,essenti:35,estim:17,evalu:[7,8,14,22,29,36],even:[22,36],event:4,event_nam:4,everi:[15,31],everyth:[12,31],exact:36,exactli:36,exampl:[3,5,9,10,12,13,16,17,27,29,31,35,36],exce:[23,36],except:[29,36],exclud:[3,8,17,28,29],exclus:20,execut:[2,30,31],exist:[7,9,10,11,14,16,31,32,34,36],expect:[29,36],explain:28,explicitli:[6,27,36],exponenti:[32,34],expos:29,expr:[3,17,27],express:[5,8,10,15,18,19,20,22,23,24,26,27,29,34,36],expression1:24,expression2:24,extend:23,extens:[3,33,35],extern:7,extra:36,extract:36,ey:[17,18,22,27],f:36,fail:[22,29],fals:[0,21,28,29,36],far:1,fatal:16,featur:[27,29],feed:36,fewer:8,field:36,file:[26,35],filter:[8,21],find:[6,15,17,27,36],first:[5,6,8,10,17,22,27,28,35],first_nam:21,fix:36,flex:35,float_kei:36,float_result:36,float_to_str:23,float_valu:36,flr:20,foaf:15,folder:16,follow:[1,3,5,6,8,10,11,13,15,16,17,20,27,28,29,35,36],fork:33,form:[8,27,36],format:[2,26,36],found:[8,12,23,27,35],four:[29,36],fourth:28,fox:8,fraction:36,friend:[17,27],friend_of_friend:17,friend_of_friends_distinct:17,from:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,27,29,30,31,32,35,36],full:[9,36],full_nam:21,function_nam:25,further:[8,27],furthermor:[27,29],futur:[8,29],g:[16,36],garfield:8,gave:8,gcc:35,gd2md:36,gekko:8,gen:16,gener:27,get:[5,12,14,15,17,36],get_actors_who_played_rol:2,get_all_actor_nam:2,get_event_year:4,github:35,give:32,given:[8,17,18,20,21,22,23,29],glib:35,glibc:35,go:[5,10,13,15],goal:33,goblin:[2,8],good:29,gordon:8,grant:35,graph:[5,6,8,9,15,26,30,33,36],graph_1:0,graph_2:0,graph_nam:[0,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,27,30,31,32,36],graph_queri:0,graphid:29,greater:[20,29,36],greatest:20,green:[2,8,18,22],group:[17,29,36],grouping_kei:27,guarante:14,h:4,ha:[8,12,16,28,29,31,36],hair_color:22,haircolor:22,handi:13,handl:33,happi:12,has_citi:28,have:[0,1,6,8,12,15,17,23,27,29,35,36],he:8,header:28,height:10,hel:23,hello:23,here:[5,27,30,36],hewwo:23,hex:36,high:[29,36],higher:17,highest:17,highlight:1,hint:30,histori:4,hold:[8,36],holland:[2,21],home:2,homecom:2,how:[5,8,10,23,29,30,36],howev:[0,1,4,5,6,11,13,25,28,29,30,36],html:[35,36],http:35,hungri:13,hybrid:1,i:[12,17,18,20,27,29,32,36],id:[0,5,6,8,9,11,12,13,18,27,36],id_field_exist:28,ident:[28,36],identifi:[3,36],ie:36,ieee754:36,ieee:36,ignor:17,ii:17,imdb:2,implement:[29,36],impli:36,implicitli:29,improv:36,includ:[8,12,14,16,17,27,28,29,36],inclus:[18,20,32,34],incom:[27,36],incompar:29,inconsist:29,incub:35,independ:[30,31,36],index:23,individu:31,inequ:29,inexact:36,infin:[29,36],inform:[27,28,30,36],information_schema:28,initdb:16,inner:[27,36],input:[21,28,36],insensit:36,insid:[27,36],inspir:33,instal:16,installcheck:16,instanc:[16,29],instead:[3,9,11,17,30,36],instruct:28,insuffici:36,int_kei:36,int_result:36,integ:[7,14,17,18,20,22,23,28,29],interest:[8,12],intermedi:8,intern:36,interpol:17,interpret:36,introduc:[8,12,15,27],ironman:2,irrespect:36,isn:[9,12],iso2:28,issu:[5,13],item:[7,12],its:[8,9,29,36],itself:[6,8,29],j:[16,32],januari:22,jeff:32,jersei:9,jo:32,joan:32,john:[21,32],johz:32,join:26,jr:2,json:36,jsonb:36,just:[8,9,10,11,12],kei:[29,36],key_valu:36,keyword:36,kind:36,kirk:2,know:[6,8,12,17,18,22,27,36],known:[0,8],l:[23,27],label:[6,11,12,13,17,27,28,31],label_nam:36,label_name_1:36,label_name_2:36,lang:16,languag:[2,4,16,33],larg:36,largest:29,last:[10,14],last_nam:21,lastli:10,later:[8,9],latter:27,lazaru:2,lc_:16,lc_all:16,lead:[23,29,36],least:[15,36],left:[29,36],left_trimmed_str:23,leftmost:23,length:[3,10,23],length_of_path:22,less:[20,29],letter:3,li:17,lib:35,libdir:35,librari:35,libreadlin:35,license_numb:0,like:[12,15,27,32],limit:[0,4,14,26,28,29,36],line:[27,30],linear:17,link:36,linux:35,list:[5,6,8,10,11,12,13,15,22,23,26,27,29,32,34],listkei:36,liter:[12,29],llo:23,ln:35,load:[2,5,17,35],load_edges_from_fil:28,load_labels_from_fil:28,locat:[31,35],logarithm:26,logic:[29,32,34],low:29,lower:[8,17],lower_str:23,lowercas:23,lowest:17,lst:[22,36],lst_head:22,lst_tail:22,lt:[5,10,32,34],m:[5,12,15,36],machin:36,made:[12,14],maguir:[2,8,21],mai:[0,17,22,25,29,30,36],make:[8,10,16,27,28,32,35,36],makefil:16,manag:36,mani:[1,8,23],manipul:15,manner:[5,36],manual:31,map1:36,map2:36,map:[3,18,21,22,29,30,31,32,34],map_valu:36,mapkei:36,martin:[8,9],match:[0,2,3,4,5,6,7,9,10,11,12,13,14,15,17,18,20,21,22,23,26,27,28,30,34],mathemat:[20,24,36],max_ag:17,maximum:[17,36],me:[17,27],mean:[8,27,36],measur:22,median:17,membership:29,mere:29,merg:26,messag:31,method:17,michael:[5,8,9],midnight:22,might:[12,36],millisecond:22,min:27,min_ag:17,min_test:17,min_val:17,minimum:17,minu:[32,34,36],miss:[12,13,29,36],mix:17,model:[29,33],modifi:29,monetari:36,more:[0,1,8,15,17,27,32,36],most:[21,36],movi:[2,8],msut:28,multi:33,multipl:[9,17,27,32,34,36],must:[0,3,9,15,27,29,31,36],n1:29,n2:29,n3:29,n:[0,4,5,6,7,10,12,14,15,17,19,21,23,27,28,32,36],name:[0,2,3,4,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,27,28,30,31,32,35,36],names_match:0,namespac:25,namespace_nam:25,nan:[29,36],natur:19,natural_logarithm:19,nearest:[17,20,36],need:[9,16,29,30,31,35],neg:[20,23,29],negat:20,negative_sign:20,neo:5,new_str:23,newli:[5,13],newlin:36,next:[10,17,36],no_step:18,no_way_hom:2,node:[6,7,8,11,13,14,15,17,18,21,22,28,29,31,36],non:[22,27],normal:13,norman:2,not_a_bool:22,not_a_float:22,not_an_integ:22,notat:29,note:[0,2,4,5,10,14,28,29,35,36],noth:[5,6,8],now:13,nproc:16,null_result:36,number:[0,7,8,15,18,19,20,22,23,24,29,36],number_of_peopl:17,numer:[17,18,26,27,29],numeric_kei:36,numeric_result:36,o:[15,32],oad_edges_from_fil:28,object:31,objects_nam:12,occur:[8,29],occurr:[9,23],offer:[27,36],ofitself:36,often:8,ohio:9,older_than_30:12,oliv:[8,9],olleh:23,omit:[23,36],onc:[5,12,17],one:[0,5,7,8,15,18,22,23,27,29,36],ones:28,onli:[4,8,10,12,14,15,16,17,27,30,35,36],open:16,opencyph:[29,33],oper:[0,26,27,29,36],oppos:36,option:[6,15,23,28,30,31],order:[0,7,14,15,17,23,26,27,35,36],ordinari:36,org:35,origin:23,orpath:6,os:35,osborn:2,other:[1,28,29,36],otherperson:15,otherwis:[30,31],our:17,out:[21,36],outgo:[15,36],outlin:29,output:[7,10,12,14,15,27,29,36],outsid:[25,29,36],over:[17,27,29],overhead:36,overlap:36,overview:26,p1:29,p2:29,p:[5,8,18,22,24,36],packag:35,pair:29,pairwis:[17,29],paramet:[12,13,28,30],parameter_nam:3,parenthesi:27,parker:2,pars:22,parser:36,part:[0,5,8,12,15,21,27,29,30,36],partial:9,particular:36,particularli:29,pass:[9,15,17,27,29,30],path:[8,12,18,22,28,29,35],pattern:[1,5,8,9,12,29],patterson:21,patti:21,peopl:15,per:27,percentil:17,percentile_cont_ag:17,percentile_disc_ag:17,perform:[8,28,32,36],person:[0,3,5,8,9,11,13,15,17,18,22,27,30,32],person_id:0,peter:[0,2],pg_catalog:25,pg_config:35,pgsql:26,physic:36,pick:28,pl:26,place:[0,3,36],placehold:12,pleas:[14,28],plpgsql:2,plu:36,plugin:35,point:[20,22,36],popul:17,portabl:36,posit:[7,13,14,20,23,28,29],positive_sign:20,posix:32,possess:31,possibl:[0,8,29,30,36],postgr:[3,29,30,35],postgresql:[29,33,35],power:19,precis:[29,36],predic:[8,12,26,29,36],prefix:[32,34],premium:36,prepar:[26,30],present:28,presid:8,previou:[8,32],primari:8,primit:29,priorit:29,privileg:35,problem:[0,27],procedur:3,process:[27,35],produc:36,progress:18,project:[10,29,33],pronounc:29,prop1:36,prop2:36,propag:36,properli:28,properti:[6,7,8,14,17,18,27,28,31,32,34],protect:0,provid:[8,33,36],put:[8,36],qualifi:27,quantiti:36,queri:[1,2,3,5,6,7,8,9,10,11,12,13,14,15,17,18,19,20,21,22,23,24,25,26,29,33,35,36],query_str:30,quot:36,r1:29,r1and:29,r2:29,r:[6,8,12,17,20,22,36],rad:24,rais:[23,36],rand:[7,14],random:20,rang:[8,20,29],rather:8,re:36,read:[3,8,15],readabl:36,readlin:35,real:36,recogn:36,recommend:[2,31,35,36],reconfigur:16,record:[7,12,14,17,27,30],refer:7,regard:8,regress:[16,28],regular:[27,29,34],reiner:[8,9],relat:[17,29,32,33,34],relationship:[5,6,8,10,11,12,13,15,17,21,29,36],releas:29,reli:[10,36],reltyp:5,remaind:[32,34],rememb:35,remov:[0,6,17,23,26,27],renam:12,replac:[2,4],replacementstr:23,repres:[24,29,32,36],represent:[18,22,36],requir:[5,6,8,11,13,27,29,36],reserv:31,respect:[16,32,34,36],rest:[32,35],restrict:[0,2,8],result1:30,result2:30,result:[0,2,4,5,6,7,8,9,10,11,13,14,17,18,19,20,21,22,23,24,25,27,29,30,31,32,36],retriev:[12,36],revers:[10,15],rewrit:27,rewritten:8,right:[8,36],rightmost:23,rob:[8,9],robert:2,role:[2,8],root:19,round:[17,36],rounded_valu:20,row:[0,2,4,5,6,8,9,10,11,12,13,15,17,18,19,20,21,22,23,24,25,27,28,32,36],rule:[10,29],run:[2,3,6,17,22,26,27,35],rwx:16,rx:16,s:[2,4,5,6,8,9,11,13,17,19,20,21,22,23,24,25,27,33,35,36],safe:27,sai:27,said:[6,36],same:[0,1,5,17,22,27,29,36],sampl:17,scalar:[4,26],scale:36,schema:35,schema_nam:0,scienc:36,scope:[5,10],search:[8,23,34],search_path:[2,17,28,35],second:[17,28],section:[1,36],see:[0,3,6,10,17,28,30,35,36],select:[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,27,28,31,32,36],semant:29,sens:36,sensit:[32,34],sensitv:32,separ:[5,12,13,15,29,36],sequenc:[8,36],sequenti:29,seri:36,server:35,set:[0,2,4,8,9,10,14,15,17,21,24,26,27,28,31,35,36],setof:30,setup:[2,26],sever:[27,36],shadow:10,shall:28,shape:15,sheen:[8,9],shorter:29,shorthand:29,should:[8,10,12,16,17,27,28,36],show:36,shown:[8,32,34,35],side:36,signific:36,signum:20,similar:[5,15],similarli:28,simpl:28,simpli:[5,13,17,36],simplifi:35,sinc:29,sine:24,singl:[1,8,11,13,18,32,33,36],size:[23,36],size_of_list:22,skip:26,slight:36,slow:36,small:36,smallest:[20,27,29],smallint:36,smith:21,so:[1,8,10,11,25,27,29,33,35,36],solut:[0,27],some:[1,17,36],someth:24,sometim:[13,29],somewhat:36,somewher:14,sort:[10,29,36],sourc:[16,28,36],space:36,special:[10,32,36],specif:[8,29],specifi:[8,10,14,21,23,27,29,36],specifii:27,spiderman:[2,8],spidermen:8,split:9,split_delimit:23,split_list:23,splitdelimit:23,sql:[1,2,3,26,27,31,33,35,36],sql_person:0,sqrt:25,squar:[19,36],stage:9,standard:[17,33,36],stark:2,start:[3,6,7,14,15,17,18,22,23,29,34,36],start_id:[12,18,28,36],start_vertex_typ:28,startid:[5,12,36],state:[10,27,28,36],statement:[0,8,12,26,30],stddevp:17,stdev_ag:17,stdevp_ag:17,stefan:22,step:[18,28],still:[5,6,11,12,13,30],stone:[8,9],storag:[33,36],store:[3,11,36],str_arrai:23,str_to_str:23,street:8,string:[3,17,18,22,26,27,29,34],string_kei:36,string_result:36,striong:32,structur:28,strung:8,style:[0,3],sub:[8,10],sub_str1:23,sub_str2:23,subgraph:[21,27],subject:[29,36],subqueri:[0,30],subscript:[32,34],subsect:0,subtract:[32,34,36],sudo:[16,35],suffix:[32,34],suit:26,superset:36,support:[4,16,30,32],sure:[10,28],surnam:[13,21],symbol:[8,12],symlink:35,sync:16,syntax:[5,7,8,14,17,18,19,20,21,22,23,24,25,30,31],system:[0,3,29,36],t:[0,9,11,12,16,22,24,29,36],tab:36,tabl:[0,2,28,31,36],table_catalog:28,table_nam:28,table_schema:28,table_typ:28,tail:22,take:[17,27,36],tangent:24,target:[30,36],taylor:13,term:[10,29,36],termin:28,test:[26,29],text:[4,36],than:[0,8,15,17,20,29,36],thei:[0,8,9,10,21,25,29,36],them:[4,5,8,10,13,17,27,29,36],themselv:8,thenfind:15,therefor:18,thereof:17,thi:[0,1,5,6,7,8,9,10,11,12,13,14,17,21,25,27,28,29,31,35,36],third:[3,36],those:15,three:[5,7,8,17,18,22,36],through:[15,27,36],thrown:[3,30],thu:[15,17,36],thunder:2,ti:36,time:[0,5,17,22,29],titl:[2,5,8],tobe:17,tobi:[2,8,21],tobia:[0,3],toc:36,togeth:8,tointeg:7,tom:[2,21],toni:2,too:36,top:[7,14,15,36],total:36,total_ag:17,trail:[23,36],transact:0,treat:[12,29,36],trigonometr:26,trim:14,trimmed_str:23,tropic:2,tropic_thund:2,truncat:36,twice:17,two:[8,12,17,18,22,23,27,28,29,31,36],type:[17,20,26,29],typecast:36,typescount:17,u:[8,16,36],umask:16,unambigu:27,unari:[32,34],unbias:17,unchang:[22,23],unclear:29,undefin:36,under:[16,27],underflow:36,underli:29,understand:36,unecessari:27,unexpect:29,unfortun:29,unicod:36,uniform:20,uniqu:[27,36],unknown:[8,36],unless:14,unlik:[3,36],unspecifi:29,unsync:16,up:[8,9,12,31,36],updat:[13,15,36],upper:8,upper_str:23,us:[1,3,5,6,9,10,11,12,16,21,23,25,26,27,28,29,30,31,32,33,36],usag:35,useless:[6,36],user:[0,4,9,26,27,28,33,35],usr:35,usual:[8,12],utc:22,utf:[16,36],uxxxx:36,v1:5,v:[0,2,3,5,6,8,9,13,17,22,27,30,32,36],vagrant:16,val:17,valu:[3,4,5,6,8,10,11,12,13,18,19,20,22,23,27,28,29,32,34,36],value1:36,value2:36,valuesgo:27,varchar:[0,2,36],variabl:[5,6,7,10,11,13,16,27,35,36],variant:17,variat:17,veri:36,vertex:[11,12,18,21,22,27,29,31],vertic:[9,12,13,14,29,31,36],vetic:28,via:29,view:[28,36],w:23,wai:[1,2,8,27],wall:8,want:[8,12,13,25,36],we:[5,17,27,29,35,36],weight:17,well:15,were:[28,29],what:27,when:[0,3,5,6,8,9,10,11,12,13,15,16,17,25,27,28,29,30,32,35,36],where:[0,3,4,5,8,9,12,15,17,18,19,20,21,22,28,29,31,32,36],wherea:36,whether:36,which:[8,10,12,14,22,23,28,30,33,36],whitespac:23,whole:[9,29,36],willam:[2,8],willem:21,within:[1,3,18,27,29],without:[2,6,8,10,27,36],word:36,work:[2,8,27,29,36],works_at:5,worth:8,would:29,write:[0,4,15,36],written:4,www:35,x:[17,22,24,27,36],y:24,ye:12,year:4,yet:8,yield:36,york:9,you:[4,5,6,8,9,10,12,13,15,28,32,35,36],your:[6,8,12,15,35],yum:35,zero:[23,36],zero_sign:20,zlib1g:35,zlib:35},titles:["Using Cypher in a CTE Expression","Overview","PL/pgSQL Functions","Prepared Statements","SQL In Cypher","CREATE","DELETE","LIMIT","MATCH","MERGE","ORDER BY","REMOVE","RETURN","SET","SKIP","WITH","Run the test suite","Aggregation Functions","List Functions","Logarithmic Functions","Numeric Functions","Predicate Functions","Scalar Functions","String Functions","Trigonometric Functions","User defined functions","Apache AGE\u2019s documentation","Aggregation","Importing graph from files","Comparability, Equality, Orderability and Equivalence","The AGE Cypher Query Format","Graphs","Operators","Overview","Operator Precedence","Setup","Data Types - An Introduction to agtype"],titleterms:{"case":32,"float":36,"function":[2,4,15,17,18,19,20,21,22,23,24,25,26,27,28],"import":28,"null":[10,17,36],"return":[5,6,7,12,13,14,17],A:31,BY:10,By:27,IN:0,In:4,The:[30,32],WITH:15,With:32,ab:20,about:28,access:36,aco:24,add:5,ag:[26,27,30,35],aggreg:[15,17,27],agtyp:[29,36],alias:12,all:[6,8,12],allow:35,ambigu:27,an:[5,7,14,30,36],apach:[26,35],asin:24,atan2:24,atan:24,auto:27,avg:17,basic:[8,32],befor:15,between:[5,29],beyond:26,bool:36,both:9,branch:15,cast:36,ceil:20,cento:35,charact:12,claus:[0,5,6,11,13,26,30],co:24,coalesc:22,code:35,collect:15,compar:29,comparison:32,composit:36,concept:29,contain:32,contribut:26,count:17,creat:[4,5,13,28,31],create_graph:31,csv:28,cte:0,cypher:[0,2,3,4,26,30,31],data:[9,17,18,27,32,36],defin:25,degre:24,delet:[6,31],descend:10,differ:29,direct:8,distinct:27,document:26,drop_graph:31,duplic:17,dynam:2,e:19,edg:[5,6,8,12,27,36],element:[12,36],end:32,end_id:22,endnod:22,entiti:36,equal:29,equival:29,exampl:[8,28],execut:3,exist:[0,21],exp:19,explan:28,express:[0,7,12,14,17,30,32],fedora:35,field:[12,28],file:28,filter:15,find:8,first:14,floor:20,format:[3,28,30],from:28,full:5,gener:36,get:[8,35],graph:[0,28,31],graphid:36,group:27,head:22,hide:27,id:[22,28],index:36,individu:36,insensit:32,instal:35,instruct:35,integ:36,introduct:[6,7,8,10,14,15,26,27,36],invalid:[16,27],join:0,kei:[18,27],label:[5,8,9,18,36],last:22,left:23,length:[8,22],limit:[7,15],list:[17,18,36],liter:36,load:28,local:16,log10:19,log:19,logarithm:19,ltrim:23,map:36,match:[8,32],max:17,merg:9,middl:14,min:17,multipl:[0,5,8,10,13],namespac:31,neg:36,node:[5,9,10,12],non:[17,35],number:17,numer:[20,36],one:13,onli:6,oper:[32,34],option:[12,35],order:[10,29],other:12,outgo:8,overview:[1,33],paramet:3,path:[5,15,21,36],per:35,percentilecont:17,percentiledisc:17,permiss:16,pgsql:2,pi:24,pl:2,posit:36,post:35,postgr:[0,31,36],pre:35,preced:[32,34],predic:21,prepar:3,properti:[5,9,10,11,12,13,21,22,36],queri:[0,4,27,30],radian:24,rand:20,rang:[18,36],regular:32,relat:8,relationship:18,releas:35,remov:[11,13],replac:23,result:[12,15],revers:23,right:23,round:20,row:[7,14],rtrim:23,run:16,s:[0,26],scalar:22,script:28,search:[15,32],select:30,session:35,set:[5,13,16],setup:[9,17,18,27,32,35],sign:20,simpl:36,sin:24,singl:[5,6,9],size:22,skip:14,slice:36,sort:[15,27],sourc:35,specif:32,specifi:9,split:23,sql:[0,4,28],sqrt:19,start:32,start_id:22,startnod:22,statement:[3,27],stdev:17,stdevp:17,string:[23,32,36],subset:[7,14],substr:23,suit:16,sum:17,superus:35,tan:24,termin:[5,6,11,13],test:16,them:15,three:14,timestamp:22,toboolean:22,tofloat:22,togeth:32,tointeg:22,tolow:23,tostr:23,toupper:23,trigonometr:24,trim:23,troubleshoot:16,two:[5,14],type:[8,22,36],ubuntu:35,uncommon:12,uniqu:12,unwant:27,us:[0,7,8,13,14,15,17,35],user:25,valid:27,valu:17,variabl:[8,12],vertex:[5,6,8,9,13,36],vertic:[5,6,8,27,28],vs:[31,36],wildcard:32,without:[17,28],work:0}}) |