jaunt_maunal
차이
문서의 선택한 두 판 사이의 차이를 보여줍니다.
| 양쪽 이전 판 이전 판 | |||
|
jaunt_maunal [2018/10/12 08:43] gsjung |
jaunt_maunal [2018/12/21 02:00] gsjung |
||
|---|---|---|---|
| 줄 33: | 줄 33: | ||
| < | < | ||
| COPY (select * from positions p, devices d where p.deviceid=d.id AND d.uniqueid IN (SELECT uniqueid FROM devices WHERE uniqueid LIKE ######)) TO '#########' | COPY (select * from positions p, devices d where p.deviceid=d.id AND d.uniqueid IN (SELECT uniqueid FROM devices WHERE uniqueid LIKE ######)) TO '#########' | ||
| + | </ | ||
| + | |||
| + | < | ||
| + | select d.name, p.* from tc_positions p, tc_devices d where p.deviceid = d.id and d.id IN (select id from tc_devices where name=ANY(' | ||
| </ | </ | ||
jaunt_maunal.txt · 마지막으로 수정됨: 2021/04/13 06:54 (바깥 편집)
