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 1pNJIV-0007p6-NA for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 20:01:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pNJHW-00036s-Kl for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 20:00:34 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pNJHW-00036g-8N for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 20:00:34 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pNJHT-0003kf-SP for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 20:00:33 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-163adf0cfc4so13771439fac.7 for ; Wed, 01 Feb 2023 12:00:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:from:content-language:to:user-agent:mime-version:date :message-id:from:to:cc:subject:date:message-id:reply-to; bh=vvL1uX3T6YKISbGAA2cnvyGfqWW7PmZ15o1PKxa3UuM=; b=mCzR5dQtqTr9fuTeSfrGhBQjKvKCAMVZvWm6bmlwymoxYmp9wp9U3tZ/x7nwsPWclV orSW3WgWuEME3i+rEkWRdpXSIFkYhBwX1o5c4kaBFZs/w0OUfzfa4+tNI8PJmek9pmTG 6fJCyxFwWRwHYRgsrfZQI4/E+Jw8c8VAD4S68UntYXHzfOA/U72mTo5o84p9mDc+rFzs ZrD7wD6BD3M4Utsf8g+FkYrIMQuckDzdKpT52jTunThJxFF9wcURntTaVYox8hQsIpIQ HotK7QgWrDpKwfYsQEaOx+A+d49z7RIrOPbVkg/XMPzbwAXUDxy4hZemXsgKuJmQeN7K oDIA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=subject:from:content-language:to:user-agent:mime-version:date :message-id:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=vvL1uX3T6YKISbGAA2cnvyGfqWW7PmZ15o1PKxa3UuM=; b=FOLOB9B/DxOuVc+cprMYmRITfYqGronlN4f0mMEVxCSB2japyJNmKwZ9vYv3zdagno 9d7feg7zHH/NI2fk8Vjv9Btc7Ije27InSXLzHboYnfIReapgNcEe2j+ikd9VFHmTxmoW XnBId1lJiQ9RMnCrwxVddvLlaQbvD2sdabtFZXUbed9TDlml8qIrzB0ZiA03WZXOcTgn bHfvYvZDdZB4twoxbd7338Shylz4WNkOSwDh6nkGSF2ceE+1RZRqQKCPxjijMccjnmPx jwqTL56cwJTB0K0Db2XpUpd/P/rqPy2rDyEWKvyr20JZNRQFlm7vhul2a0A0NHYvGbmT TTsA== X-Gm-Message-State: AO0yUKWKduCZTECcm3kNmbr7hXsthSm7OTr/36Phw+K/9k63+oBgKLpS S89dAwdP+Yh4fRVqiDSGr990yiGYB9I= X-Google-Smtp-Source: AK7set9NRmbXg1nyllprY+MI0/H9D7s0p43hZmeoRo5nx0OnVQ7PkdThT+8Qu5fPt/hb1wzXRcy52Q== X-Received: by 2002:a05:6870:e394:b0:15f:dbec:7cbe with SMTP id x20-20020a056870e39400b0015fdbec7cbemr1886103oad.27.1675281630063; Wed, 01 Feb 2023 12:00:30 -0800 (PST) Received: from [192.168.1.66] (108-250-206-84.lightspeed.nworla.sbcglobal.net. [108.250.206.84]) by smtp.googlemail.com with ESMTPSA id ky12-20020a056871404c00b0014c8b5d54b2sm8149492oab.20.2023.02.01.12.00.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 01 Feb 2023 12:00:29 -0800 (PST) Content-Type: multipart/alternative; boundary="------------r2keLxrxfq8CCbu0vxzeVnSH" Message-ID: <3833b34a-a4c1-14ee-fcdc-0fa74baa2cd8@gmail.com> Date: Wed, 1 Feb 2023 14:00:28 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 To: pgsql-general@lists.postgresql.org Content-Language: en-US From: Ron Subject: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------r2keLxrxfq8CCbu0vxzeVnSH Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit v12.13 https://www.postgresql.org/docs/12/sql-select.html The docs say that one of these are required in the SELECT list. [ * |/|expression|/ [ [ AS ]/|output_name|/ ] [, ...] ] However, *not* mentioning anything also works, though acts like COUNT(*). test=# select * from sales_detail;  cust_id |        order_ts         | seq_no | inventory_id | quantity | price  | tax_rate ---------+-------------------------+--------+--------------+----------+--------+----------        1 | 2020-01-05 13:05:42.567 |      1 |        12345 | 5.80 |  28.40 |    0.092        1 | 2020-01-05 13:05:42.567 |      2 |        23456 | 6.00 |  98.40 |    0.092        1 | 2020-01-05 13:05:42.567 |      3 |        34567 | 1.80 |  67.00 |    0.092        1 | 2020-01-05 13:05:42.567 |      4 |        45678 | 450.00 |   2.00 |    0.092        1 | 2020-02-05 13:05:42.567 |      1 |         6575 | 5.20 | 567.00 |    0.045        1 | 2020-02-05 13:05:42.567 |      2 |         4565 | 456.00 | 545.00 |    0.045        1 | 2020-02-05 13:05:42.567 |      3 |         7899 | 768.00 | 432.00 |    0.045        1 | 2020-02-05 13:05:42.567 |      4 |         2354 | 556.00 | 890.00 |    0.045        1 | 2020-03-05 13:05:42.567 |      1 |         6575 | 5.20 | 567.00 |    0.045        1 | 2020-03-05 13:05:42.567 |      2 |         4565 | 456.00 | 545.00 |    0.045        1 | 2020-03-05 13:05:42.567 |      3 |         7899 | 768.00 | 432.00 |    0.045 (11 rows) test=# test=# select  from sales_detail; -- (11 rows) Is it interpreting the lack of column names, expressions or "*" as a null expression? We only noticed this when someone forgot to put an asterisk in a psql query and thought something was broken.  We expected psql to throw a syntax error... -- Born in Arizona, moved to Babylonia. --------------r2keLxrxfq8CCbu0vxzeVnSH Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 PGh0bWw+DQogIDxoZWFkPg0KDQogICAgPG1ldGEgaHR0cC1lcXVpdj0iY29udGVudC10eXBl IiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNoYXJzZXQ9VVRGLTgiPg0KICA8L2hlYWQ+DQogIDxi b2R5Pg0KICAgIHYxMi4xMzxicj4NCiAgICA8YnI+DQogICAgPGEgY2xhc3M9Im1vei10eHQt bGluay1mcmVldGV4dCIgaHJlZj0iaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8x Mi9zcWwtc2VsZWN0Lmh0bWwiPmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTIv c3FsLXNlbGVjdC5odG1sPC9hPjxicj4NCiAgICA8YnI+DQogICAgVGhlIGRvY3Mgc2F5IHRo YXQgb25lIG9mIHRoZXNlIGFyZSByZXF1aXJlZCBpbiB0aGUgU0VMRUNUIGxpc3QuPGJyPg0K ICAgIDxwcmUgY2xhc3M9InN5bm9wc2lzIiBzdHlsZT0iYm94LXNpemluZzogYm9yZGVyLWJv eDsgZm9udC1mYW1pbHk6IG1vbm9zcGFjZSwgbW9ub3NwYWNlOyBmb250LXNpemU6IDE2LjJw eDsgbWFyZ2luOiAxcmVtIDBweDsgb3ZlcmZsb3c6IGF1dG87IGRpc3BsYXk6IGJsb2NrOyBj b2xvcjogcmdiKDAsIDAsIDApOyBiYWNrZ3JvdW5kLWNvbG9yOiB2YXIoLS1kb2Njb250ZW50 LXByZS1jb2RlLWJnLWNvbG9yKTsgYm9yZGVyLXJhZGl1czogMC4yNXJlbTsgZm9udC13ZWln aHQ6IDQwMDsgcGFkZGluZzogMC44cmVtOyBib3JkZXI6IDFweCBzb2xpZCB2YXIoLS1wZ2Nv bnRlbnQtcHJlLWJkci1jb2xvcik7IGZvbnQtc3R5bGU6IG5vcm1hbDsgZm9udC12YXJpYW50 LWxpZ2F0dXJlczogbm9ybWFsOyBmb250LXZhcmlhbnQtY2Fwczogbm9ybWFsOyBsZXR0ZXIt c3BhY2luZzogbm9ybWFsOyBvcnBoYW5zOiAyOyB0ZXh0LWFsaWduOiBsZWZ0OyB0ZXh0LWlu ZGVudDogMHB4OyB0ZXh0LXRyYW5zZm9ybTogbm9uZTsgd2lkb3dzOiAyOyB3b3JkLXNwYWNp bmc6IDBweDsgLXdlYmtpdC10ZXh0LXN0cm9rZS13aWR0aDogMHB4OyB0ZXh0LWRlY29yYXRp b24tdGhpY2tuZXNzOiBpbml0aWFsOyB0ZXh0LWRlY29yYXRpb24tc3R5bGU6IGluaXRpYWw7 IHRleHQtZGVjb3JhdGlvbi1jb2xvcjogaW5pdGlhbDsiPlsgKiB8IDxlbSBjbGFzcz0icmVw bGFjZWFibGUiIHN0eWxlPSJib3gtc2l6aW5nOiBib3JkZXItYm94OyBmb250LXN0eWxlOiBp dGFsaWM7IGZvbnQtd2VpZ2h0OiA4MDA7Ij48Y29kZSBzdHlsZT0iYm94LXNpemluZzogYm9y ZGVyLWJveDsgZm9udC1mYW1pbHk6IG1vbm9zcGFjZSwgbW9ub3NwYWNlOyBmb250LXNpemU6 IGluaGVyaXQ7IGNvbG9yOiBpbmhlcml0OyBvdmVyZmxvdy13cmFwOiBicmVhay13b3JkOyBi YWNrZ3JvdW5kLWNvbG9yOiB2YXIoLS1kb2Njb250ZW50LXByZS1jb2RlLWJnLWNvbG9yKTsg Ym9yZGVyLXJhZGl1czogMC4yNXJlbTsgbWFyZ2luOiAwLjZyZW0gMHB4OyBmb250LXdlaWdo dDogODAwOyB3b3JkLWJyZWFrOiBub3JtYWw7Ij5leHByZXNzaW9uPC9jb2RlPjwvZW0+IFsg WyBBUyBdIDxlbSBjbGFzcz0icmVwbGFjZWFibGUiIHN0eWxlPSJib3gtc2l6aW5nOiBib3Jk ZXItYm94OyBmb250LXN0eWxlOiBpdGFsaWM7IGZvbnQtd2VpZ2h0OiA4MDA7Ij48Y29kZSBz dHlsZT0iYm94LXNpemluZzogYm9yZGVyLWJveDsgZm9udC1mYW1pbHk6IG1vbm9zcGFjZSwg bW9ub3NwYWNlOyBmb250LXNpemU6IGluaGVyaXQ7IGNvbG9yOiBpbmhlcml0OyBvdmVyZmxv dy13cmFwOiBicmVhay13b3JkOyBiYWNrZ3JvdW5kLWNvbG9yOiB2YXIoLS1kb2Njb250ZW50 LXByZS1jb2RlLWJnLWNvbG9yKTsgYm9yZGVyLXJhZGl1czogMC4yNXJlbTsgbWFyZ2luOiAw LjZyZW0gMHB4OyBmb250LXdlaWdodDogODAwOyB3b3JkLWJyZWFrOiBub3JtYWw7Ij5vdXRw dXRfbmFtZTwvY29kZT48L2VtPiBdIFssIC4uLl0gXTwvcHJlPg0KICAgIEhvd2V2ZXIsIDxi Pm5vdDwvYj4gbWVudGlvbmluZyBhbnl0aGluZyBhbHNvIHdvcmtzLCB0aG91Z2ggYWN0cw0K ICAgIGxpa2UgQ09VTlQoKikuPGJyPg0KICAgIDxicj4NCiAgICA8Zm9udCBmYWNlPSJtb25v c3BhY2UiPnRlc3Q9IyBzZWxlY3QgKiBmcm9tIHNhbGVzX2RldGFpbDs8YnI+DQogICAgICDC oGN1c3RfaWQgfMKgwqDCoMKgwqDCoMKgIG9yZGVyX3RzwqDCoMKgwqDCoMKgwqDCoCB8IHNl cV9ubyB8IGludmVudG9yeV9pZCB8DQogICAgICBxdWFudGl0eSB8IHByaWNlwqAgfCB0YXhf cmF0ZSA8YnI+DQotLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0t LSstLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tLS08YnI+DQog ICAgICDCoMKgwqDCoMKgwqAgMSB8IDIwMjAtMDEtMDUgMTM6MDU6NDIuNTY3IHzCoMKgwqDC oMKgIDEgfMKgwqDCoMKgwqDCoMKgIDEyMzQ1IHzCoMKgwqDCoA0KICAgICAgNS44MCB8wqAg MjguNDAgfMKgwqDCoCAwLjA5Mjxicj4NCiAgICAgIMKgwqDCoMKgwqDCoCAxIHwgMjAyMC0w MS0wNSAxMzowNTo0Mi41NjcgfMKgwqDCoMKgwqAgMiB8wqDCoMKgwqDCoMKgwqAgMjM0NTYg fMKgwqDCoMKgDQogICAgICA2LjAwIHzCoCA5OC40MCB8wqDCoMKgIDAuMDkyPGJyPg0KICAg ICAgwqDCoMKgwqDCoMKgIDEgfCAyMDIwLTAxLTA1IDEzOjA1OjQyLjU2NyB8wqDCoMKgwqDC oCAzIHzCoMKgwqDCoMKgwqDCoCAzNDU2NyB8wqDCoMKgwqANCiAgICAgIDEuODAgfMKgIDY3 LjAwIHzCoMKgwqAgMC4wOTI8YnI+DQogICAgICDCoMKgwqDCoMKgwqAgMSB8IDIwMjAtMDEt MDUgMTM6MDU6NDIuNTY3IHzCoMKgwqDCoMKgIDQgfMKgwqDCoMKgwqDCoMKgIDQ1Njc4IHzC oMKgDQogICAgICA0NTAuMDAgfMKgwqAgMi4wMCB8wqDCoMKgIDAuMDkyPGJyPg0KICAgICAg wqDCoMKgwqDCoMKgIDEgfCAyMDIwLTAyLTA1IDEzOjA1OjQyLjU2NyB8wqDCoMKgwqDCoCAx IHzCoMKgwqDCoMKgwqDCoMKgIDY1NzUgfMKgwqDCoMKgDQogICAgICA1LjIwIHwgNTY3LjAw IHzCoMKgwqAgMC4wNDU8YnI+DQogICAgICDCoMKgwqDCoMKgwqAgMSB8IDIwMjAtMDItMDUg MTM6MDU6NDIuNTY3IHzCoMKgwqDCoMKgIDIgfMKgwqDCoMKgwqDCoMKgwqAgNDU2NSB8wqDC oA0KICAgICAgNDU2LjAwIHwgNTQ1LjAwIHzCoMKgwqAgMC4wNDU8YnI+DQogICAgICDCoMKg wqDCoMKgwqAgMSB8IDIwMjAtMDItMDUgMTM6MDU6NDIuNTY3IHzCoMKgwqDCoMKgIDMgfMKg wqDCoMKgwqDCoMKgwqAgNzg5OSB8wqDCoA0KICAgICAgNzY4LjAwIHwgNDMyLjAwIHzCoMKg wqAgMC4wNDU8YnI+DQogICAgICDCoMKgwqDCoMKgwqAgMSB8IDIwMjAtMDItMDUgMTM6MDU6 NDIuNTY3IHzCoMKgwqDCoMKgIDQgfMKgwqDCoMKgwqDCoMKgwqAgMjM1NCB8wqDCoA0KICAg ICAgNTU2LjAwIHwgODkwLjAwIHzCoMKgwqAgMC4wNDU8YnI+DQogICAgICDCoMKgwqDCoMKg wqAgMSB8IDIwMjAtMDMtMDUgMTM6MDU6NDIuNTY3IHzCoMKgwqDCoMKgIDEgfMKgwqDCoMKg wqDCoMKgwqAgNjU3NSB8wqDCoMKgwqANCiAgICAgIDUuMjAgfCA1NjcuMDAgfMKgwqDCoCAw LjA0NTxicj4NCiAgICAgIMKgwqDCoMKgwqDCoCAxIHwgMjAyMC0wMy0wNSAxMzowNTo0Mi41 NjcgfMKgwqDCoMKgwqAgMiB8wqDCoMKgwqDCoMKgwqDCoCA0NTY1IHzCoMKgDQogICAgICA0 NTYuMDAgfCA1NDUuMDAgfMKgwqDCoCAwLjA0NTxicj4NCiAgICAgIMKgwqDCoMKgwqDCoCAx IHwgMjAyMC0wMy0wNSAxMzowNTo0Mi41NjcgfMKgwqDCoMKgwqAgMyB8wqDCoMKgwqDCoMKg wqDCoCA3ODk5IHzCoMKgDQogICAgICA3NjguMDAgfCA0MzIuMDAgfMKgwqDCoCAwLjA0NTxi cj4NCiAgICAgICgxMSByb3dzKTxicj4NCiAgICAgIDxicj4NCiAgICAgIHRlc3Q9IyA8YnI+ DQogICAgICB0ZXN0PSMgc2VsZWN0wqAgZnJvbSBzYWxlc19kZXRhaWw7PGJyPg0KICAgICAg LS08YnI+DQogICAgICAoMTEgcm93cyk8YnI+DQogICAgPC9mb250Pjxicj4NCiAgICBJcyBp dCBpbnRlcnByZXRpbmcgdGhlIGxhY2sgb2YgY29sdW1uIG5hbWVzLCBleHByZXNzaW9ucyBv ciAiKiIgYXMgYQ0KICAgIG51bGwgZXhwcmVzc2lvbj88YnI+DQogICAgPGJyPg0KICAgIFdl IG9ubHkgbm90aWNlZCB0aGlzIHdoZW4gc29tZW9uZSBmb3Jnb3QgdG8gcHV0IGFuIGFzdGVy aXNrIGluIGENCiAgICBwc3FsIHF1ZXJ5IGFuZCB0aG91Z2h0IHNvbWV0aGluZyB3YXMgYnJv a2VuLsKgIFdlIGV4cGVjdGVkIHBzcWwgdG8NCiAgICB0aHJvdyBhIHN5bnRheCBlcnJvci4u Ljxicj4NCiAgICA8YnI+DQogICAgPGRpdiBjbGFzcz0ibW96LXNpZ25hdHVyZSI+LS0gPGJy Pg0KICAgICAgQm9ybiBpbiBBcml6b25hLCBtb3ZlZCB0byBCYWJ5bG9uaWEuPC9kaXY+DQog IDwvYm9keT4NCjwvaHRtbD4NCg== --------------r2keLxrxfq8CCbu0vxzeVnSH--