Received: from intragate.popso.it (intergate.popso.it [194.243.98.135]) by hub.org (8.9.3/8.9.3) with SMTP id HAA77278 for ; Wed, 25 Aug 1999 07:09:03 -0400 (EDT) (envelope-from Giampiero.Raschetti@popso.it) Received: tid NAA01258; Wed, 25 Aug 1999 13:05:45 +0200 X-Authentication-Warning: intragate: Host ssinw011.popso.it claimed to be popso.it Sender: jimi@intragate.popso.it Message-ID: <37C3CEB9.AB63E3DE@popso.it> Date: Wed, 25 Aug 1999 13:08:41 +0200 From: Giampiero Raschetti X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.5-15 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: PgSQL 6.5.1 and Group BY pb Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms39809F47C7F8D1D3F0A4A7E5" This is a cryptographically signed message in MIME format. --------------ms39809F47C7F8D1D3F0A4A7E5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Running PostgreSQL-6.5.1 (rpm version distributed for linux on redhat 6.0) GROUP BY complitely fails bash$ psql template1 template1=> CREATE TABLE "gruppi" ("id" int4 NOT NULL,"nome" character varying(32)); CREATE template1=> CREATE TABLE "usergroup" ("id" int4 NOT NULL,"uid" int4 NOT NULL,"gid" int4 NOT NULL); CREATE template1=> insert into gruppi values (0,'ciao'); INSERT 31637 1 template1=> insert into gruppi values (1,'pippo'); INSERT 31638 1 template1=> insert into usergroup values (0,1,2); INSERT 31639 1 template1=> insert into usergroup values (0,2,3); INSERT 31640 1 template1=> insert into usergroup values (1,2,3); INSERT 31641 1 And now the output query with GROUP BY: template1=> SELECT g.nome,u.uid,u.id FROM gruppi g, usergroup u GROUP BY g.nome; ERROR: Illegal use of aggregates or non-group column in target list template1=> SELECT nome,id FROM gruppi GROUP BY nome; ERROR: Illegal use of aggregates or non-group column in target list And now the output query with SELECT DISTINCT: template1=> SELECT DISTINCT ON g.nome g.nome,u.uid,u.id from gruppi g, usergroup u; ERROR: parser: parse error at or near "." -- Best Regards ---------------------------- Giampiero Raschetti Sistemi Innovativi Banca Popolare di Sondrio ---------------------------- --------------ms39809F47C7F8D1D3F0A4A7E5 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIIHrwYJKoZIhvcNAQcCoIIHoDCCB5wCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHAaCC BdEwggKQMIIB+aADAgECAgMAm8UwDQYJKoZIhvcNAQEEBQAwgbkxCzAJBgNVBAYTAlpBMRUw EwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxlMRowGAYDVQQKExFU aGF3dGUgQ29uc3VsdGluZzEpMCcGA1UECxMgVGhhd3RlIFBGIFJTQSBJSyAxOTk4LjkuMTYg MTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBSU0EgSXNzdWVyIDE5 OTguOS4xNjAeFw05OTAzMDgxNDAzNTZaFw0wMDAzMDcxNDAzNTZaME4xHzAdBgNVBAMTFlRo YXd0ZSBGcmVlbWFpbCBNZW1iZXIxKzApBgkqhkiG9w0BCQEWHGdpYW1waWVyby5yYXNjaGV0 dGlAcG9wc28uaXQwXDANBgkqhkiG9w0BAQEFAANLADBIAkEApIaNCBaZMD9TL8Shxj0vkHxY dtEmNpPEWFun75AdRJ6/Jxp1bhV5HO02UwMUrzwmlFBSKgU02OFRxXtNDxGA8wIDAQABo1Qw UjARBglghkgBhvhCAQEEBAMCBaAwDgYDVR0PAQH/BAQDAgWgMAwGA1UdEwEB/wQCMAAwHwYD VR0jBBgwFoAU/j5gnGuMD7DYM8bKxh5YsHE4teAwDQYJKoZIhvcNAQEEBQADgYEAn6o/B6kK 93HPOUKd3M7qV9TVhT9fq0SKXN79f5bWWgKN3rbFfVSlx0dc4Tc14yT+45xM9t2jelUGBavV f4aEfFqb4uvFIS8v6GS4tjEY3+QvltiDvTvSRyfwDWZF6otsodVKyLv9CVVs0e8e9An2jp1Z Nk+IVwi0k/6ZQoqwSRUwggM5MIICoqADAgECAgEKMA0GCSqGSIb3DQEBBAUAMIHRMQswCQYD VQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAY BgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYDVQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZp Y2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgQ0ExKzAp BgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0ZS5jb20wHhcNOTgwOTE2MTc1 NTM0WhcNMDAwOTE1MTc1NTM0WjCBuTELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4g Q2FwZTEUMBIGA1UEBxMLRHVyYmFudmlsbGUxGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5n MSkwJwYDVQQLEyBUaGF3dGUgUEYgUlNBIElLIDE5OTguOS4xNiAxNzo1NTE2MDQGA1UEAxMt VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIFJTQSBJc3N1ZXIgMTk5OC45LjE2MIGfMA0GCSqG SIb3DQEBAQUAA4GNADCBiQKBgQDEpeXU1NBfCALuByF9JL+ra44e6yAHAhWEa4/QkyQfG53u aLK5LE/pk2cXEBceoflDQSO5MKp2l7vz5/2BwLUxi/amUCZU8pUo6xmkHpcesOK4m8EEmjLQ PAlsT+Q1T/B2vwATA09FCGDz/LTQkAGKEsmcun9S6iqTNTY8POQ1LwIDAQABozcwNTASBgNV HRMBAf8ECDAGAQH/AgEAMB8GA1UdIwQYMBaAFHJJwnM0xlX0C3ZygX539IfnxrIOMA0GCSqG SIb3DQEBBAUAA4GBACzHgh8BQz4Hj+5pXKlkgvjAlq2TK8ubUNdAmoHCuqZ2nTyVQNxVweFV gnmrCimm1QzhVyg+j/m71d8Nk1iqWy2LjzPk3VgVNXZyFSm9QvRakgt3X50n25otThuCBo7S jVa7ld7bDGUF3pWeAt1TF76+/GvDGiJ6FCthvcKfXnpaMYIBpjCCAaICAQEwgcEwgbkxCzAJ BgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxFDASBgNVBAcTC0R1cmJhbnZpbGxl MRowGAYDVQQKExFUaGF3dGUgQ29uc3VsdGluZzEpMCcGA1UECxMgVGhhd3RlIFBGIFJTQSBJ SyAxOTk4LjkuMTYgMTc6NTUxNjA0BgNVBAMTLVRoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBS U0EgSXNzdWVyIDE5OTguOS4xNgIDAJvFMAkGBSsOAwIaBQCgfTAYBgkqhkiG9w0BCQMxCwYJ KoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw05OTA4MjUxMTA4NDJaMB4GCSqGSIb3DQEJDzER MA8wDQYIKoZIhvcNAwICASgwIwYJKoZIhvcNAQkEMRYEFFIyBY4m9YeO7G/ND2nu6prjIMpS MA0GCSqGSIb3DQEBAQUABEA5Fdy8ULkTF2CbZ+pYA8rk/8n/mQMu0Lxr0wIwxiUw1ioJ4N8+ 5OdtcwI0ioOQU9DSXB35HOKP+n5kah7UByGj --------------ms39809F47C7F8D1D3F0A4A7E5--