pgsql: Reconsider the representation of join alias Vars.
Tom Lane <[email protected]> Thu, 09 Jan 2020 16:57:09 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.cvs |
|---|---|
| Message-ID | <[email protected]> |
--===============6474547116162181663== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVjb25zaWRlciB0aGUgcmVwcmVzZW50YXRpb24gb2Ygam9pbiBhbGlhcyBWYXJzLgoKVGhlIGNv cmUgaWRlYSBvZiB0aGlzIHBhdGNoIGlzIHRvIG1ha2UgdGhlIHBhcnNlciBnZW5lcmF0ZSBqb2lu IGFsaWFzClZhcnMgKHRoYXQgaXMsIG9uZXMgd2l0aCB2YXJubyBwb2ludGluZyB0byBhIEpPSU4g UlRFKSBvbmx5IHdoZW4gdGhlCmFsaWFzIFZhciBpcyBhY3R1YWxseSBkaWZmZXJlbnQgZnJvbSBh bnkgcmF3IGpvaW4gaW5wdXQsIHRoYXQgaXMgYSB0eXBlCmNvZXJjaW9uIGFuZC9vciBDT0FMRVND RSBpcyBuZWNlc3NhcnkgdG8gZ2VuZXJhdGUgdGhlIGpvaW4gb3V0cHV0IHZhbHVlLgpPdGhlcndp c2UganVzdCBnZW5lcmF0ZSB2YXJuby92YXJhdHRubyBwb2ludGluZyB0byB0aGUgcmVsZXZhbnQg am9pbgppbnB1dCBjb2x1bW4uCgpJbiBlZmZlY3QsIHRoaXMgbWVhbnMgdGhhdCB0aGUgcGxhbm5l cidzIGZsYXR0ZW5fam9pbl9hbGlhc192YXJzKCkKdHJhbnNmb3JtYXRpb24gaXMgYWxyZWFkeSBk b25lIGluIHRoZSBwYXJzZXIsIGZvciBhbGwgY2FzZXMgZXhjZXB0CihhKSBjb2x1bW5zIHRoYXQg YXJlIG1lcmdlZCBieSBKT0lOIFVTSU5HIGFuZCBhcmUgdHJhbnNmb3JtZWQgaW4gdGhlCnByb2Nl c3MsIGFuZCAoYikgd2hvbGUtcm93IGpvaW4gVmFycy4gIEluIHByaW5jaXBsZSB0aGF0IHdvdWxk IGFsbG93CnVzIHRvIHNraXAgZG9pbmcgZmxhdHRlbl9qb2luX2FsaWFzX3ZhcnMoKSBpbiBtYW55 IG1vcmUgcXVlcmllcyB0aGFuCndlIGRvIG5vdywgYnV0IHdlIGRvbid0IGhhdmUgcXVpdGUgZW5v dWdoIGluZnJhc3RydWN0dXJlIHRvIGtub3cgdGhhdAp3ZSBjYW4gZG8gc28gLS0tIGluIHBhcnRp Y3VsYXIgdGhlcmUncyBubyBjaGVhcCB3YXkgdG8ga25vdyB3aGV0aGVyCnRoZXJlIGFyZSBhbnkg d2hvbGUtcm93IGpvaW4gVmFycy4gIEknbSBub3Qgc3VyZSBpZiBpdCdzIHdvcnRoIHRoZQp0cm91 YmxlIHRvIGFkZCBhIFF1ZXJ5LWxldmVsIGZsYWcgZm9yIHRoYXQsIGFuZCBpbiBhbnkgY2FzZSBp dCBzZWVtcwpsaWtlIGZpdCBtYXRlcmlhbCBmb3IgYSBzZXBhcmF0ZSBwYXRjaC4gIEJ1dCBldmVu IHdpdGhvdXQgc2tpcHBpbmcgdGhlCndvcmsgZW50aXJlbHksIHRoaXMgc2hvdWxkIG1ha2UgZmxh dHRlbl9qb2luX2FsaWFzX3ZhcnMoKSBmYXN0ZXIsCnBhcnRpY3VsYXJseSB3aGVyZSB0aGVyZSBh cmUgbmVzdGVkIGpvaW5zIHRoYXQgaXQgcHJldmlvdXNseSBoYWQgdG8KZmxhdHRlbiByZWN1cnNp dmVseS4KCkFuIGVzc2VudGlhbCBwYXJ0IG9mIHRoaXMgY2hhbmdlIGlzIHRvIHJlcGxhY2UgVmFy IG5vZGVzJwp2YXJub29sZC92YXJvYXR0bm8gZmllbGRzIHdpdGggdmFybm9zeW4vdmFyYXR0bm9z eW4sIHdoaWNoIGhhdmUKY29uc2lkZXJhYmx5IG1vcmUgdGlnaHRseS1kZWZpbmVkIG1lYW5pbmdz IHRoYW4gdGhlIG9sZCBmaWVsZHM6IHdoZW4KdGhleSBkaWZmZXIgZnJvbSB2YXJuby92YXJhdHRu bywgdGhleSBpZGVudGlmeSB0aGUgVmFyJ3MgcG9zaXRpb24gaW4KYW4gYWxpYXNlZCBKT0lOIFJU RSwgYW5kIHRoZSBqb2luIGFsaWFzIGlzIHdoYXQgcnVsZXV0aWxzLmMgc2hvdWxkCnByaW50IGZv ciB0aGUgVmFyLiAgVGhpcyBpcyBuZWNlc3NhcnkgYmVjYXVzZSB0aGUgdmFybm8gY2hhbmdlCmRl c3Ryb3llZCBydWxldXRpbHMuYydzIGFiaWxpdHkgdG8gZmluZCB0aGUgSk9JTiBSVEUgZnJvbSB0 aGUgVmFyJ3MKdmFybm8uCgpBbm90aGVyIHdheSBpbiB3aGljaCB0aGlzIGNoYW5nZSBicm9rZSBy dWxldXRpbHMuYyBpcyB0aGF0IGl0J3Mgbm8KbG9uZ2VyIGZlYXNpYmxlIHRvIGRldGVybWluZSwg ZnJvbSBhIEpPSU4gUlRFJ3Mgam9pbmFsaWFzdmFycyBsaXN0LAp3aGljaCBqb2luIGNvbHVtbnMg Y29ycmVzcG9uZCB0byB3aGljaCBjb2x1bW5zIG9mIHRoZSBqb2luJ3MgaW1tZWRpYXRlCmlucHV0 IHJlbGF0aW9ucy4gIChJZiB0aG9zZSBhcmUgc3ViLWpvaW5zLCB0aGUgam9pbmFsaWFzdmFycyBl bnRyaWVzCm1heSBwb2ludCB0byBjb2x1bW5zIG9mIHRoZWlyIGJhc2UgcmVsYXRpb25zLCBub3Qg dGhlIHN1Yi1qb2lucy4pCkJ1dCB0aGF0IHdhcyBhIGhvcnJpZCBtZXNzIHJlcXVpcmluZyBhIGxv dCBvZiBmcmFnaWxlIGFzc3VtcHRpb25zCmFscmVhZHksIHNvIGxldCdzIGp1c3QgYml0ZSB0aGUg YnVsbGV0IGFuZCBhZGQgc29tZSBtb3JlIEpPSU4gUlRFCmZpZWxkcyB0byBtYWtlIGl0IG1vcmUg c3RyYWlnaHRmb3J3YXJkIHRvIGZpZ3VyZSB0aGF0IG91dC4gIEkgYWRkZWQKdHdvIGludGVnZXIt TGlzdCBmaWVsZHMgY29udGFpbmluZyB0aGUgcmVsZXZhbnQgY29sdW1uIG51bWJlcnMgZnJvbQp0 aGUgbGVmdCBhbmQgcmlnaHQgaW5wdXQgcmVscywgcGx1cyBhIGNvdW50IG9mIGhvdyBtYW55IG1l cmdlZCBjb2x1bW5zCnRoZXJlIGFyZS4KClRoaXMgcGF0Y2ggZGVwZW5kcyBvbiB0aGUgUGFyc2VO YW1lc3BhY2VDb2x1bW4gaW5mcmFzdHJ1Y3R1cmUgdGhhdApJIGFkZGVkIGluIGNvbW1pdCA1ODE1 Njk2YmMuICBUaGUgYmlnZ2VzdCBiaXQgb2YgY29kZSBjaGFuZ2UgaXMKcmVzdHJ1Y3R1cmluZyB0 cmFuc2Zvcm1Gcm9tQ2xhdXNlSXRlbSdzIGhhbmRsaW5nIG9mIEpPSU5zIHNvIHRoYXQKdGhlIFBh cnNlTmFtZXNwYWNlQ29sdW1uIGRhdGEgaXMgcHJvcGFnYXRlZCB1cHdhcmQgY29ycmVjdGx5LgoK T3RoZXIgdGhhbiB0aGF0IGFuZCB0aGUgcnVsZXV0aWxzIGZpeGVzLCBldmVyeXRoaW5nIHByZXR0 eSBtdWNoCmp1c3Qgd29ya3MsIHRob3VnaCBzb21lIHByb2Nlc3NpbmcgaXMgbm93IGluZXNzZW50 aWFsLiAgSSBncmFiYmVkCnR3byBwaWVjZXMgb2YgbG93LWhhbmdpbmcgZnJ1aXQgaW4gdGhhdCBs aW5lOgoKMS4gSW4gZmluZF9leHByX3JlZmVyZW5jZXMsIHdlIGRvbid0IG5lZWQgdG8gcmVjdXJz ZSBpbnRvIGpvaW4gYWxpYXMKVmFycyBhbnltb3JlLiAgVGhlcmUgYXJlbid0IGFueSBleGNlcHQg Zm9yIHJlZmVyZW5jZXMgdG8gbWVyZ2VkIFVTSU5HCmNvbHVtbnMsIHdoaWNoIGFyZSBtb3JlIHBy b3Blcmx5IGhhbmRsZWQgd2hlbiB3ZSBzY2FuIHRoZSBqb2luJ3MgUlRFLgpUaGlzIGNoYW5nZSBh Y3R1YWxseSBmaXhlcyBhbiBlZGdlLWNhc2UgaXNzdWU6IHdlIHdpbGwgbm93IHJlY29yZCBhCmRl cGVuZGVuY3kgb24gYW55IHR5cGUtY29lcmNpb24gZnVuY3Rpb24gcHJlc2VudCBpbiBhIFVTSU5H IGNvbHVtbidzCmpvaW5hbGlhc3ZhciwgZXZlbiBpZiB0aGF0IGpvaW4gY29sdW1uIGhhcyBubyBy ZWZlcmVuY2VzIGluIHRoZSBxdWVyeQp0ZXh0LiAgVGhlIG9kZHMgb2YgdGhlIG1pc3NpbmcgZGVw ZW5kZW5jeSBjYXVzaW5nIGEgcHJvYmxlbSBzZWVtIHF1aXRlCnNtYWxsOiB5b3UnZCBoYXZlIHRv IHBvc2l0IHNvbWVib2R5IGRyb3BwaW5nIGFuIGltcGxpY2l0IGNhc3QgYmV0d2Vlbgp0d28gZGF0 YSB0eXBlcywgd2l0aG91dCByZW1vdmluZyB0aGUgdHlwZXMgdGhlbXNlbHZlcywgYW5kIHRoZW4g aGF2aW5nCmEgc3RvcmVkIHJ1bGUgY29udGFpbmluZyBhIHdob2xlLXJvdyBWYXIgZm9yIGEgam9p biB3aG9zZSBVU0lORyBtZXJnZQpkZXBlbmRzIG9uIHRoYXQgY2FzdC4gIFNvIEkgZG9uJ3QgZmVl bCBhIGdyZWF0IG5lZWQgdG8gY2hhbmdlIHRoaXMgaW4KdGhlIGJhY2sgYnJhbmNoZXMuICBCdXQg aW4gdGhlb3J5IHRoaXMgd2F5IGlzIG1vcmUgY29ycmVjdC4KCjIuIG1hcmtSVEVGb3JTZWxlY3RQ cml2IGFuZCBtYXJrVGFyZ2V0TGlzdE9yaWdpbiBkb24ndCBuZWVkIHRvIHJlY3Vyc2UKaW50byBq b2luIGFsaWFzIFZhcnMgZWl0aGVyLCBiZWNhdXNlIHRoZSBjYXNlcyB0aGV5IGNhcmUgYWJvdXQg ZG9uJ3QKYXBwbHkgdG8gYWxpYXMgVmFycyBmb3IgVVNJTkcgY29sdW1ucyB0aGF0IGFyZSBzZW1h bnRpY2FsbHkgZGlzdGluY3QKZnJvbSB0aGUgdW5kZXJseWluZyBjb2x1bW5zLiAgVGhpcyByZW1v dmVzIHRoZSBvbmx5IGNhc2UgaW4gd2hpY2gKbWFya1ZhckZvclNlbGVjdFByaXYgY291bGQgYmUg Y2FsbGVkIHdpdGggTlVMTCBmb3IgdGhlIFJURSwgc28gYWRqdXN0CnRoZSBjb21tZW50cyB0byBk ZXNjcmliZSB0aGF0IGhhY2sgYXMgYmVpbmcgc3RyaWN0bHkgaW50ZXJuYWwgdG8KbWFya1JURUZv clNlbGVjdFByaXYuCgpjYXR2ZXJzaW9uIGJ1bXAgcmVxdWlyZWQgZHVlIHRvIGNoYW5nZXMgaW4g c3RvcmVkIHJ1bGVzLgoKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS83MTE1LjE1Nzc5 ODY2NDZAc3NzLnBnaC5wYS51cwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzljZTc3ZDc1YzVhYjA5 NDYzN2NjNGE0NDYyOTZkYzNiZTZlM2MyMjEKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CnNyYy9iYWNrZW5kL2NhdGFsb2cvZGVwZW5kZW5jeS5jICAgICAgICAgfCAgNjYgKysrKy0tLS0K c3JjL2JhY2tlbmQvbm9kZXMvY29weWZ1bmNzLmMgICAgICAgICAgICB8ICAgNyArLQpzcmMvYmFj a2VuZC9ub2Rlcy9lcXVhbGZ1bmNzLmMgICAgICAgICAgIHwgIDExICstCnNyYy9iYWNrZW5kL25v ZGVzL21ha2VmdW5jcy5jICAgICAgICAgICAgfCAgMTAgKy0Kc3JjL2JhY2tlbmQvbm9kZXMvb3V0 ZnVuY3MuYyAgICAgICAgICAgICB8ICAgNyArLQpzcmMvYmFja2VuZC9ub2Rlcy9yZWFkZnVuY3Mu YyAgICAgICAgICAgIHwgICA3ICstCnNyYy9iYWNrZW5kL29wdGltaXplci9wbGFuL3NldHJlZnMu YyAgICAgfCAgMzkgKystLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvYXBwZW5kaW5mby5j ICB8ICAgOSArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXJhbWFzc2lnbi5jIHwgICA3 ICstCnNyYy9iYWNrZW5kL3BhcnNlci9hbmFseXplLmMgICAgICAgICAgICAgfCAgIDMgKwpzcmMv YmFja2VuZC9wYXJzZXIvcGFyc2VfY2xhdXNlLmMgICAgICAgIHwgMTk5ICsrKysrKysrKysrKyst LS0tLS0tLS0tLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfcmVsYXRpb24uYyAgICAgIHwgIDgz ICsrKysrLS0tLS0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX3RhcmdldC5jICAgICAgICB8ICAx OCArLS0Kc3JjL2JhY2tlbmQvcmV3cml0ZS9yZXdyaXRlTWFuaXAuYyAgICAgICB8ICAxOCArKy0K c3JjL2JhY2tlbmQvdXRpbHMvYWR0L3J1bGV1dGlscy5jICAgICAgICB8IDI1MyArKysrKysrKysr Ky0tLS0tLS0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oICAg ICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcGFyc2Vub2Rlcy5oICAgICAgICAgICB8 ICAyNyArKystCnNyYy9pbmNsdWRlL25vZGVzL3ByaW1ub2Rlcy5oICAgICAgICAgICAgfCAgNDIg KysrLS0Kc3JjL2luY2x1ZGUvcGFyc2VyL3BhcnNlX3JlbGF0aW9uLmggICAgICB8ICAgMyArCjE5 IGZpbGVzIGNoYW5nZWQsIDQyMSBpbnNlcnRpb25zKCspLCAzOTAgZGVsZXRpb25zKC0pCgo= --===============6474547116162181663==--