Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pujoW-0007ii-5c for pgsql-general@arkaria.postgresql.org; Fri, 05 May 2023 01:00:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pujoV-0007GF-4T for pgsql-general@arkaria.postgresql.org; Fri, 05 May 2023 01:00:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pujoT-0007G5-TZ for pgsql-general@lists.postgresql.org; Fri, 05 May 2023 01:00:46 +0000 Received: from mail-os0jpn01olkn2085.outbound.protection.outlook.com ([40.92.98.85] helo=JPN01-OS0-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pujoQ-000a2u-CI for pgsql-general@lists.postgresql.org; Fri, 05 May 2023 01:00:44 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=C2QKBmHK9I05w0HRArJO/aCslJyj7opdKiGs+7q4xIEQ1cciGvUBEYhgqdFDWqax83higka0styI5ncT9kdUj1IwjNPLD4CtsIZQy0U+bvSTU8Uv0zJLSffZ1tvVYasb8nuFd3c1+eJ7Ohfkz1DPYmzC9vlVkB5L5qW10COrtUgpkw9epRM+PTSnBnOUsEkqEu9db9xSEXhxsdIKBYG6A/obk6gf4sBcEr2af6L04hRYyP3A1XjAV0IQwMfGt0lZeKQmGLVtJYoPK1LhlvmQeAVYH7J58QPDCGiDAY1I/dWdq+6zXR/8GU+6nAj4QHsJQdgQ8LiUibD65puPw1vhnA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=Lk/9GLc8FimXbsr7rugpTZ/Ia8pb734lUlSsNbm2p1Y=; b=JtmUAgI4sb+MTRErXcjiYty0y2O+5h/LLEyzGYmGCtSYLIJsyVN0wxNMoxhgmXXii3uEIVspTuE/5xNuGMB+ZaYUSWuT4GRdxQgzDyRS3/yEqCq2GedR5GeUb3x0eH4R5PyHEek6/RU6xaG+tc59HCRNmc858sn8NZaTxUwXzweYrH0yis2//SA1SbW5CK5IL/Mnp6xORZZI0j1G3BV7S6RlLn2wyoFPbssrEHY26oZ25VNm+2qDm78iOOSTre59Kofpgn1TPlZNFazaD1BweY1QuKAgsdSHlozymOZW0yabxrao2ItYhGkLYOc84ym/eUttgPJF+5oTPIPgTsx1og== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=Lk/9GLc8FimXbsr7rugpTZ/Ia8pb734lUlSsNbm2p1Y=; b=GMt23oaKVT/z2lSa3Y8tP1b/NLPbe8YSLaRmqhjL0nYKfk7B1Ry3uc8Tr8yH24eGbXSeaj3hbq9eKATDFvYj+4+pL/77kJ1YriyozdK1srpH0KoRRzhLTsdQ7LGESAvhxEuco8xacsaqZE2POFh5XjFsDobpxyohOJFoh7gn5zfOtDDYYJRJ19W2SHkwC/mAtIP4aTcqBc4zggqNAOttpwi1BPfbALghU+zQJmVPSV9nB15zuBvCipgJo3BUiPFo2HRINdkZ5DwmYVUIM1qVi+hcsH89n3cW1KWIAbDIqKw1DSWxby8K7YoR6eKcoU68WipyK5lS45wPYEYsh+q/6A== Received: from TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM (2603:1096:402:32::7) by TYWP286MB2401.JPNP286.PROD.OUTLOOK.COM (2603:1096:400:17c::8) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6363.27; Fri, 5 May 2023 01:00:37 +0000 Received: from TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM ([fe80::3ead:11bd:f5cd:7d14]) by TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM ([fe80::3ead:11bd:f5cd:7d14%4]) with mapi id 15.20.6363.027; Fri, 5 May 2023 01:00:37 +0000 From: Wen Yi To: PostgreSQL General Subject: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? Thread-Topic: What type of Compiler to SQL? Memory-Image (Load-and-Go) Format? Thread-Index: AQHZfuxBSb8OfndaoEeukdQyCyQOYA== Date: Fri, 5 May 2023 01:00:37 +0000 Message-ID: Accept-Language: zh-CN, en-US Content-Language: zh-CN X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [c47z/6JqxcujFA4eARfKmHSObsXWGqQOH4VOVU+WZT4nOruDWbjqidpULXV2GCHy] x-ms-publictraffictype: Email x-ms-traffictypediagnostic: TYAP286MB0636:EE_|TYWP286MB2401:EE_ x-ms-office365-filtering-correlation-id: 04ee2e59-1e74-43b6-e9d5-08db4d042361 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: XMCz2PF5qrbrsY/1wTpS/Kyu8buVFmEDEOWnffoGdPE08N2obH9ZGzpq5QGEk6VftdANJ1lgVggQLFJC6EiPtsBYTiAlWliGgPB2GgY5ApSIlZGbGmn2fBMWsxvaNkAiXWDzpVUxIOngaSQ7kTeGdaLACxl4fuhHqTAY19Kie9xpV3G/0Nh73Pn+vZx4FgXPFSjhjBFaCwNQ0lgbW1+y2PmUbyiwKamzZ65H8YfOcLYjxJGFkS/SVH0ane1k7MBWSbKf0X9/0Lpp79wyO18tGIqPThw/xMlZZwNLTelUNMYb/Rma/zQkIfXESD3Pa6AdMqAXT0+5rtK0AQAKd9RS94zFU4YG0UekwAWEQgkafFeR6B5ELXtmOY2YyVPO91wJ7Xl77L9elewfDhqyvDjh2xrr3apW+K7zodkyce2SRt/87US4mThTTSqjRJkeUf+/4zDIwNaO7AS1j8gSesF+Ab7+Joqq52Q3eIAbbQrxSPoakm96lpYdzXgsoKoGQjx+kIE8F4vxZ8cIbd/RRUY/BOgaIhsZNdzBljg9JqNzJtYvW1LLkWdNOjIjqBcJkhme x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?gb2312?B?L04zcE1WTEVBcTRxQ0R6MDkwcXF5L0JuOWlHMTZwOTdiMys2czFLeXdySkVz?= =?gb2312?B?RCtmWlAyME9KUnY3anA2LzlQYjlYaktKR2JHdVUyRmpGYU1HQ3hMKy9TcjN2?= =?gb2312?B?R280Yk9zWFdpN1lKWmRWUmFvaklickNpZENLb0g5NjF0eUJKY1p0ZjI0UXM5?= =?gb2312?B?UkpvYzgzcUxPSkhBSHhuK3VrVnBWbkhka0pmWDFocmxZRkZOZGkxRGxScVR4?= =?gb2312?B?MVRVdTZmU2VoVG1CUkZScWh0bWRObVdGQ0pwa3JBN1lPbHNGMVZ1SWhYMHBB?= =?gb2312?B?b2xJSE1ZUjlEcFVQK2RpMkxiaHdGZG91dTJNODhxczJwMTkrYlhCV1NZVmFq?= =?gb2312?B?cEpzWGl1ZmFKUVV2UlNZbXVBOWJhVVNaTUlMMlVkNXlUSjE2dzFNeTJLcS92?= =?gb2312?B?M29jUzFiQTJ5QXBMMmpZQzNCclVyTGZOaFozcTdFY0F0VW0rdnpvUnRjOGxq?= =?gb2312?B?RGg0cVVPN0hTREI4Vjl0L3FtVWlhaXAwaUFES1NPMUZ5MTFoVWh3WDBiWkhs?= =?gb2312?B?QVlFd0t0MVJ3cEVrZG5qa0IzZC84R2ZBSkJqLzcrcERhbGErV1R2SktUcXBx?= =?gb2312?B?UnNKU1lINXBueTg2d0FYUXczbFE1UXV6czVYWSsyQXVTaDhaSjl1eTRQS3Fl?= =?gb2312?B?MzE3REc2YmxmOUZ1bTU0MUgrUHpTeWc4Vk41dyt0aUMrb3FzY2wrT2dyMElY?= =?gb2312?B?dmVFRVQvSWlBbHFvcmxpbW5OZ2JZZWE3Y2ZWM2UwY1pxVVp2T3Q2M0E2NDlh?= =?gb2312?B?ZFZlbzRoZHRiazZHMFJ6WEJNWFBFbEJIeStScEZFdWRTYjh5bTBJUVpkb0tO?= =?gb2312?B?QXNocG1OTHVaODBGR2doYXo1QmorcERPU3ZsVkVDbmp3RXBBN3VQNktCL2JE?= =?gb2312?B?ZFpPS2Z5T3ZkbXZUaUpHVnduN0hhaFp3Z3VUY2t6dXBQU2lPek9jTzVHVHpq?= =?gb2312?B?bC9BOU5VcHlZZ2xUUGdGL0JRM2ExWlk2dHdkakZKazJiNEhNWVJaM0xVWC9G?= =?gb2312?B?c0daTU9nQkRLdlhvQzJCTzJZUUxTeDErWDNMU0JYdmdrbHJsdVVRSlpzV3Bu?= =?gb2312?B?SHlNbzRmUmhYZDZBYndNeU4wY3FWSy9pQzk3NXRyMW00R1ZKbjdVbFV0T3pT?= =?gb2312?B?UnN0N1c4b2JzOXZ4OFlPUDZqNXYxQ1ZlNjRuWEJzQWIydW81V21JSmRVaHVo?= =?gb2312?B?cEExNGpINFBrMWxrYXJnQW5UZVlDanBLZnpnVENEQkdaS29CbjVoMDZKWE9X?= =?gb2312?B?L3FXL3dUWXpEcEorK3NQSDJCRUZ1Y0pmWDl6MFFzeHFiUUtsUCsvME1rc2Q0?= =?gb2312?B?VmNMUk9KNjV6ZDdBM2VHQm9wUlFKSmhPNGlBcE51d3RDTDhwVjV2SUZMbnZ6?= =?gb2312?B?UlBYT0pIT2xTb084aG5US2p4SlhxS3IvYkl0ODBqLzdFZWpxd3RVdHdQeUd4?= =?gb2312?B?dGxHdldaMGxCcVVQSzVXTmJqNzZaWFFBOGcwSE9MNEZTYmkvMkVnLzBrbFhu?= =?gb2312?B?SjVzZFRFdFhRWU40TEd6b3FxdmJMUkIxWkFoTmRQVEtYbGZacnNxdWM5YWdY?= =?gb2312?B?ZmpWRkQ3U3dlNk1oS3doRnhLSmhGZXMvSkhvYi9QMVMwMzhYYTQ5WDJoSm54?= =?gb2312?B?Q1lja2sxY0c2SHhlc0VwUnVOMWVNUm03N3hGb3d1WWl5MitHQXk1T3FYQ1BO?= =?gb2312?B?WHcvRndjL3VlcXlJeWFJR1ZXMGVBdVl1Z2puUHZycyswQVFsdERtcFd3PT0=?= Content-Type: multipart/alternative; boundary="_000_TYAP286MB063667EC1939D2E9D18C5C4FA9729TYAP286MB0636JPNP_" MIME-Version: 1.0 X-OriginatorOrg: outlook.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-CrossTenant-Network-Message-Id: 04ee2e59-1e74-43b6-e9d5-08db4d042361 X-MS-Exchange-CrossTenant-originalarrivaltime: 05 May 2023 01:00:37.1744 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000 X-MS-Exchange-Transport-CrossTenantHeadersStamped: TYWP286MB2401 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_TYAP286MB063667EC1939D2E9D18C5C4FA9729TYAP286MB0636JPNP_ Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: base64 SGkgdGVhbSwNCkkgYW0gYSBuZXdiaWUgdG8gdGhlIHBvc3RncmVzLg0KV2hlbiBJIGFtIHN0dWR5 aW5nIHRoZSBjb21waWxlcix0aGUgdGV4dCBib29rIHRlbGwgbWUgdGhlcmUgaXMgdGhlcmUgdHlw ZSBvZiBjb21waWxlci4NCg0KICAxLiAgQXNzZW1ibHkgTGFuZ3VhZ2UgRm9ybWF0DQogIDIuICBS ZWxvY2F0YWJsZSBCaW5hcnkgRm9ybWF0DQogIDMuICBNZW1vcnktSW1hZ2UgKExvYWQtYW5kLUdv KSBGb3JtYXQNCg0KSSBjaGVjayB0aGUgcG9zdGdyZXMncyBzcWwgY29tcGlsZXIsIGFuZCBpdCdz IGFjaGlldmVkIGJ5IGxleCAmIHlhY2MuDQpTbyBXaGF0IHR5cGUgb2YgQ29tcGlsZXIgdG8gU1FM PyBJcyBNZW1vcnktSW1hZ2UgKExvYWQtYW5kLUdvKSBGb3JtYXQgPw0KDQpUaGFua3MgaW4gYWR2 YW5jZSENCg0KWW91cnMsDQpXZW5ZaQ0K --_000_TYAP286MB063667EC1939D2E9D18C5C4FA9729TYAP286MB0636JPNP_ Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable
Hi team,
I am a newbie to the postgres.
When I am studying the compiler,the text book tell me there is there type o= f compiler.
  1. <= span>Assembly Language Format
  2. Relocatable Binary Format
  3. Memory-Image (Load-and-Go) Format
I check the postgres's sql compiler, and it's= achieved by lex & yacc.
So What type of= Compiler to SQL? Is Memory-Image (Load-and-Go) Format ?

Thanks in advance!

Yours,
WenYi
--_000_TYAP286MB063667EC1939D2E9D18C5C4FA9729TYAP286MB0636JPNP_--