Home
Sign Up
Sign In
V2EX
›
PostgreSQL
PostgreSQL 中如何模拟 MySQL 的 order by FIELD()功能?
fancy2020
·
May 19, 2020
· 3697 views
This topic created in 2209 days ago, the information mentioned may be changed or developed.
MySQL
postgresql
order
Field
1 replies
•
2020-05-19 08:08:11 +08:00
1
raquelken
May 19, 2020
order by array_position(array[5, 4, 2, 3]::integer[], target_table.integer_id)
About
·
Help
·
Advertise
·
Blog
·
API
·
FAQ
·
Solana
·
2646 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 29ms ·
UTC 11:50
·
PVG 19:50
·
LAX 04:50
·
JFK 07:50
♥ Do have faith in what you're doing.
❯