第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

為了賬號(hào)安全,請(qǐng)及時(shí)綁定郵箱和手機(jī)立即綁定
已解決430363個(gè)問(wèn)題,去搜搜看,總會(huì)有你想問(wèn)的

PSQL 運(yùn)算符在 postgresql 中不存在

PSQL 運(yùn)算符在 postgresql 中不存在

Go
慕蓋茨4494581 2022-08-24 16:07:39
這是我的原始查詢,它適用于針對(duì)同一數(shù)據(jù)庫(kù)的pg_admin:WITH myconstants (nb_pieces,nb_room,is_fiber) as (        values (0,0,true) )SELECT     pbuy.name, seller.name as seller_name, fiche.fiberFROM     on_plan_buy pbuyINNER JOIN      card_fiche fiche      ON pbuy.uuid = fiche.ad_uuidINNER JOIN     on_plan_seller seller     ON pbuy.seller_id = seller.idINNER JOIN        myconstants conste        ON trueWHERE pbuy.code_insee IN ('92108','75018')        AND pbuy.price <= 9999999 AND pbuy.price >= 0        AND CASE WHEN conste.is_fiber = false THEN true ELSE fiche.fiber = true ENDLIMIT 100;但是當(dāng)我在golang中這樣做時(shí):query = `WITH myconstants (nb_pieces,nb_room,is_fiber) as (    values ($3,$4,$5) )SELECT     pbuy.nameFROM     ` + tableOnPlan + ` pbuyINNER JOIN    card_fiche fiche    ON pbuy.uuid = fiche.ad_uuidINNER JOIN    myconstants conste    ON trueWHERE pbuy.code_insee IN ('` + strings.Join(gsm.CodeInsee, "','") + `')    AND pbuy.price <= $1 AND pbuy.price >= $2    AND CASE WHEN conste.is_fiber = false THEN true ELSE fiche.fiber = true ENDLIMIT 100;`//AND CASE WHEN conste.nb_pieces = 0 THEN pbuy.piece > 0 ELSE pbuy.piece = conste.nb_pieces END//AND CASE WHEN conste.nb_room = 0 THEN pbuy.chambre > 0 ELSE pbuy.chambre = conste.nb_room END//AND CASE WHEN conste.is_fiber = false THEN true ELSE fiche.fiber = true ENDfmt.Println(query)err = db.Select(&response.Offers, query, gsm.PriceMax, gsm.PriceMin, gsm.NbRoom, gsm.NbChamber, gsm.Fiber)
查看完整描述

1 回答

?
吃雞游戲

TA貢獻(xiàn)1829條經(jīng)驗(yàn) 獲得超7個(gè)贊

我猜PostgreSQL不知道CTE中的列是什么類型。當(dāng)你在這樣說(shuō)的時(shí)候:pg_admin


WITH myconstants (nb_pieces,nb_room,is_fiber) as (

    values (0,0,true)

)

每個(gè)人都知道這是一個(gè)布爾值,所以一切都有效。但是,當(dāng)您在 Go 中使用它時(shí):true


WITH myconstants (nb_pieces,nb_room,is_fiber) as (

    values ($3,$4,$5)

)

驅(qū)動(dòng)程序可能不知道要使用什么類型,因此它具有類型文本,并最終嘗試與 進(jìn)行比較。text$5conste.is_fiberconste.is_fiber = falsetextboolean


你應(yīng)該能夠通過(guò)一些投射來(lái)解決這個(gè)問(wèn)題:


WITH myconstants (nb_pieces, nb_room, is_fiber) as (

    values ($3::int, $4::int, $5::boolean)

)


查看完整回答
反對(duì) 回復(fù) 2022-08-24
  • 1 回答
  • 0 關(guān)注
  • 120 瀏覽
慕課專欄
更多

添加回答

舉報(bào)

0/150
提交
取消
微信客服

購(gòu)課補(bǔ)貼
聯(lián)系客服咨詢優(yōu)惠詳情

幫助反饋 APP下載

慕課網(wǎng)APP
您的移動(dòng)學(xué)習(xí)伙伴

公眾號(hào)

掃描二維碼
關(guān)注慕課網(wǎng)微信公眾號(hào)