Home
Sign Up
Sign In
V2EX
›
PostgreSQL
PostgreSQL 中如何模拟 MySQL 的 order by FIELD()功能?
fancy2020
·
May 19, 2020
· 3912 views
This topic created in 2300 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
·
Privacy
·
Solana
·
2027 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 32ms ·
UTC 16:13
·
PVG 00:13
·
LAX 09:13
·
JFK 12:13
♥ Do have faith in what you're doing.
❯