RE: 'order by' and 'desc' not working in subquery using 'not in' - Mailing list pgsql-bugs

From Dong, Meng
Subject RE: 'order by' and 'desc' not working in subquery using 'not in'
Date
Msg-id NHEKJKOKOJFOJLPMNIFKKEKDCCAA.eddy@securities.com
Whole thread Raw
In response to 'order by' and 'desc' not working in subquery using 'not in'  (pgsql-bugs@postgresql.org)
List pgsql-bugs
SGkgUmFodWwsDQoNCkhhdmUgeW91IHRyaWVkIHRvIHF1b3RlIGVhY2ggdGFi
bGUgbmFtZSBhbmQgY29sdW1uIG5hbWUgYnkgICIgLCBhbmQgY29uc3RhbnQg
YnkgJyA/IEluIHlvdXIgY2FzZSwgdHJ5DQoNCg0KIGRlbGV0ZSBmcm9tICJy
ZXBvcnR0YWJsZSIgd2hlcmUgKCAic3J2U2VydmVyaWQiID0gJ3NlcnZlcmlk
JykgYW5kDQooICJycHRyZXBvcnRpZCIgbm90IGluKHNlbGVjdCAicnB0cmVw
b3J0aWQiIGZyb20gInJlcG9ydHRhYmxlIg0Kd2hlcmUgKCAic3J2c2VydmVy
aWQiID0gJ3NlcnZlcmlkJyBvcmRlciBieSAicnB0dGltZXN0YW1wIiBkZXNj
KSkpOw0KDQoNCkFwcHJvcHJpYXRlIHF1b3RpbmcgY2FuIGhlbHAgUG9zdGdy
ZVNRTCB1bmRlcnN0YW5kIFNRTCB3aXRob3V0IGFtYmlndWl0eS4NCg0KDQoN
Cg0KDQogICAgDQoNCg0KRWRkeQ0KRm9ybWF0dGVyL1Byb2dyYW1tZXIsDQpJ
bnRlcm5ldCBTZWN1cml0aWVzIEluYy4gQ2hpbmEgKElTSSkNClJtIDIwMiwg
QnJpZ2h0IENoaW5hIENoYW5nIEFuIEJsZGcuDQo3IEppYW4gR3VvIE1lbiBO
ZWkgQXZlLg0KQmVpamluZyAxMDAwMDUsIENoaW5hDQoNCkUtbWFpbDogZWRk
eUBzZWN1cml0aWVzLmNvbQ0KQSBFdXJvbW9uZXkgSW5zdGl0dXRpb25hbCBJ
bnZlc3RvciBDb21wYW55DQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0t
DQpGcm9tOiBwZ3NxbC1idWdzLW93bmVyQHBvc3RncmVzcWwub3JnDQpbbWFp
bHRvOnBnc3FsLWJ1Z3Mtb3duZXJAcG9zdGdyZXNxbC5vcmddT24gQmVoYWxm
IE9mDQpwZ3NxbC1idWdzQHBvc3RncmVzcWwub3JnDQpTZW50OiBUdWVzZGF5
LCBKdWx5IDMxLCAyMDAxIDQ6MTYgUE0NClRvOiBwZ3NxbC1idWdzQHBvc3Rn
cmVzcWwub3JnDQpTdWJqZWN0OiBbQlVHU10gJ29yZGVyIGJ5JyBhbmQgJ2Rl
c2MnIG5vdCB3b3JraW5nIGluIHN1YnF1ZXJ5IHVzaW5nICdub3QNCmluJw0K
DQoNClJhaHVsIEdhZGUgKFJhaHVsX2dAaXAuZXRoLm5ldCkgcmVwb3J0cyBh
IGJ1ZyB3aXRoIGEgc2V2ZXJpdHkgb2YgMQ0KVGhlIGxvd2VyIHRoZSBudW1i
ZXIgdGhlIG1vcmUgc2V2ZXJlIGl0IGlzLg0KDQpTaG9ydCBEZXNjcmlwdGlv
bg0KJ29yZGVyIGJ5JyBhbmQgJ2Rlc2MnIG5vdCB3b3JraW5nIGluIHN1YnF1
ZXJ5IHVzaW5nICdub3QgaW4nDQoNCkxvbmcgRGVzY3JpcHRpb24NCkhlbGxv
LA0KIEkgYW0gZmFjaW5nIHR3byBiaWcgcHJvYmxlbXMsdGhleSBtYXkgbm90
IGJlIHJlYWxseSBiaWcgYnV0IGluIG15IGNhc2UgdGhlc2UgYXJlIGJpZyA6
DQogMSkgdGVtcG9yYXJ5IHRhYmxlcyBjYW4gbm90IGJlIGNyZWF0ZWQgaW5z
aWRlIGZ1bmN0aW9uIHVzaW5nIFBML3Bnc3FsDQogMikgb3JkZXIgYnkgYW5k
IGRlc2Mga2V5d29yZHMgYXJlIG5vdCBmdW5jdGlvbmluZyBpbnNpZGUgc3Vi
cXVlcnkNCiAgIA0KaW4gdGhlIGZvbGxvd2luZyBxdWVyeSBpIGFtIHRyeWlu
ZyB0byBkZWxldGUgYWxsIHRoZSByb3dzIGV4Y2VwdCB0aGUgdG9wIDIwIHJv
d3MgZnJvbSByZXBvcnR0YWJsZS4NCkhvdyBpIGNhbiBkbyB0aGlzLg0KaSBo
YXZlIGRvbmUgdGhpcyBpbiBNU1NRTCB1c2luZyBzYW1lIHN5bnRheA0KDQpP
dXQgb2YgdGhlc2UgdHdvIDJuZCBwcm9ibGVtIGlzIGltcG9ydGFudCBmb3Ig
bWUsDQpwbGFzZSB0ZWxsIG1lIHdoYXQgdG8gZG8sDQogICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAtLS0gVGhhbmtzIGZvciByZXNwb25z
ZSAtLS0tDQoNCg0KU2FtcGxlIENvZGUNCiBkZWxldGUgZnJvbSByZXBvcnR0
YWJsZSB3aGVyZSAoc3J2U2VydmVyaWQ9c2VydmVyaWQpIGFuZA0KKHJwdHJl
cG9ydGlkIG5vdCBpbihzZWxlY3QgcnB0cmVwb3J0aWQgZnJvbSByZXBvcnR0
YWJsZQ0Kd2hlcmUgKHNydnNlcnZlcmlkPXNlcnZlcmlkIG9yZGVyIGJ5IHJw
dHRpbWVzdGFtcCBkZXNjKSkpOw0KDQpObyBmaWxlIHdhcyB1cGxvYWRlZCB3
aXRoIHRoaXMgcmVwb3J0DQoNCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tKGVuZCBvZiBicm9hZGNhc3QpLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tDQpUSVAgMzogaWYgcG9zdGluZy9yZWFkaW5nIHRocm91Z2ggVXNlbmV0
LCBwbGVhc2Ugc2VuZCBhbiBhcHByb3ByaWF0ZQ0Kc3Vic2NyaWJlLW5vbWFp
bCBjb21tYW5kIHRvIG1ham9yZG9tb0Bwb3N0Z3Jlc3FsLm9yZyBzbyB0aGF0
IHlvdXINCm1lc3NhZ2UgY2FuIGdldCB0aHJvdWdoIHRvIHRoZSBtYWlsaW5n
IGxpc3QgY2xlYW5seSANCg0K

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: 'order by' and 'desc' not working in subquery using 'not in'
Next
From: Mark Stosberg
Date:
Subject: Using nulls with earthdistance operator crashes backend