我正在尝试使用pqdriver对Go中的PostgreSQL数据库执行以下查询:SELECTCOUNT(id)FROMtagsWHEREidIN(1,2,3)哪里1,2,3在slicetags:=[]string{"1","2","3"}处传递.我试过很多不同的东西,比如:s:="("+strings.Join(tags,",")+")"iferr:=Db.QueryRow(`SELECTCOUNT(id)FROMtagsWHEREidIN$1`,s,).Scan(&num);err!=nil{log.Println(err)}结果为pq:syntaxerroratornear"$1"
我有以下字符串:-1,856,32,0,0,0.000000,0.0000000,0,0,137,0,0,0,1400,0,101,0,0,0,42,00,0,0,0,0,0,0,00,0,0,0,0,0,554,0-1,841,1,0,0,0.000000,0.0000000,0,0,163,0,0,0,1820,0,120,0,0,0,43,00,0,0,0,0,0,0,00,0,0,0,0,0,517,0然后我使用分隔符-1拆分它,这意味着将有一个由2个元素组成的数组(我们称它为array1)。现在,假设array1的第一个元素我想用\r\n再次拆分它,这将是一个数组(array
我不确定如何使postgres查询2dslice中的where(col1,col2)我尝试了以下方法:`CREATETABLEtable2(idCHAR(27)NOTNULL,latFLOAT8NOTNULL,lonFLOAT8NOTNULL,PRIMARYKEY(id));latlongdata:=[][]float64{}latlongdata=append(latlongdata,[]float64{1.2,2.3},)latlongdata=append(latlongdata,[]float64{1.3,2.4},)..............................