Home
Sign Up
Sign In
V2EX
›
PostgreSQL
PostgreSQL 中如何模拟 MySQL 的 order by FIELD()功能?
fancy2020
·
May 19, 2020
· 3911 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
·
2985 Online
Highest 6679
·
Select Language
创意工作者们的社区
World is powered by solitude
VERSION: 3.9.8.5 · 23ms ·
UTC 14:11
·
PVG 22:11
·
LAX 07:11
·
JFK 10:11
♥ Do have faith in what you're doing.
❯