分类：走索引

2021
01-26

PostgreSQL模糊匹配走索引的操作

场景lower(name)like'pf%'createtableusers(idintprimarykey,namevarchar(255));Createorreplacefunctionrandom_string(lengthinteger)returnstextas$$declarecharstext[]:='{0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z}';resulttext:='';iinteger:=0;beginiflength<0thenraiseexception'Givenlengt... 继续阅读 >