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