| | |
|---|
| | | " (SELECT\r\n"
|
|---|
| | | + " N.OTYPE AS DEVICE_TYPE,\r\n"
|
|---|
| | | + " 'XXX' AS FACTORY,\r\n"
|
|---|
| | | + " N.title AS DEVICE_NAME\r\n"
|
|---|
| | | + " N.title AS DEVICE_NAME,\r\n"
|
|---|
| | | + " 0 AS POS_X,\r\n"
|
|---|
| | | + " 0 AS POS_Y\r\n"
|
|---|
| | | + " FROM\r\n"
|
|---|
| | | + " (SELECT * FROM sd_names.sd_dev_pressure WHERE ver_timee = '5000-01-01'::timestamp) N\r\n"
|
|---|
| | | + ") T";
|
|---|
| | |
|---|
| | | + " N.OTYPE AS DEVICE_TYPE,\r\n"
|
|---|
| | | + " 'XXX' AS FACTORY,\r\n"
|
|---|
| | | + " N.title AS DEVICE_NAME,\r\n"
|
|---|
| | | + " 0 AS POS_X,\r\n"
|
|---|
| | | + " 0 AS POS_Y,\r\n"
|
|---|
| | | + " Q.otype AS QUOTA_TYPE,\r\n"
|
|---|
| | | + " Q.oname AS QUOTA_NAME\r\n"
|
|---|
| | | + " FROM\r\n"
|
|---|
