Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2AAC8475E1F for ; Wed, 20 Nov 2002 04:45:15 -0500 (EST) Received: from smtp.ualg.pt (smtp.ualg.pt [193.136.224.8]) by postgresql.org (Postfix) with ESMTP id 9DE8D475D70 for ; Wed, 20 Nov 2002 04:45:04 -0500 (EST) Received: from localhost (smtp.ualg.pt [127.0.0.1]) by smtp.ualg.pt (Postfix) with ESMTP id 3DEF04BC1F; Wed, 20 Nov 2002 09:45:05 +0000 (WET) Received: from ualg.pt (unknown [10.10.20.125]) by smtp.ualg.pt (Postfix) with ESMTP id B8CCF4BC0A; Wed, 20 Nov 2002 09:45:03 +0000 (WET) Message-ID: <3DDB5995.7060403@ualg.pt> Date: Wed, 20 Nov 2002 09:44:53 +0000 From: Luis Sousa User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020623 Debian/1.0.0-0.woody.1 MIME-Version: 1.0 To: Michiel Lange Cc: pgsql-sql@postgresql.org Subject: Re: trying to learn plpqsql... so please forgive.. References: <5.1.0.14.0.20021120010436.00b4c920@192.168.1.3> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms060506010209040204090203" X-Virus-Scanned: by AMaViS new-20020517 X-Razor-id: 043f3fbc8de5bfef13ce92b513eee276fbf72623 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/299 X-Sequence-Number: 10441 This is a cryptographically signed message in MIME format. --------------ms060506010209040204090203 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit > When I do an 'INSERT INTO VALUES ' > and on the table is a serial primary key named p_key. > As I want this number to be auto-generated, but use it as a 'customer > number', I want to create this function to return the value of this > insert. Try this: SELECT currval(); Luis Sousa --------------ms060506010209040204090203 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 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIJPDCCAvwwggJloAMCAQICAwcgpDANBgkqhkiG9w0BAQQFADCBkjEL MAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJ Q2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRpZmlj YXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBSU0Eg MjAwMC44LjMwMB4XDTAyMDQwMjEzNDYxNloXDTAzMDQwMjEzNDYxNlowQTEf MB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEeMBwGCSqGSIb3DQEJ ARYPbGxzb3VzYUB1YWxnLnB0MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIB CgKCAQEArq+CLmsIQV5pSRtuNd9sptT22gTUwt0UReWfSlCTApnNcGDQCiS8 nluhr5AWbJWhhIVHQETSKWlT+y09KsYf7AeW1zBQWSUJjhpCDYd8n+T0SxFl 24ZZJhZQ57kVJ7iNzJ7WPYQGk06zoRWgtnFcvVuA1az0vhwWHNk8+1JaCTeW lwjPRptJZ78CNiN2prAoEoI9m7/jUW6iTJmpNinzkIa1qpKEdPrCQM/dhuk6 JDl4qmiQ2a87I/aiRJCPtTBIl/Zt2Vjde5Br2qR8pWisjaoVl9ntJJvni9cl XJGk/uO4iwza7IL2K6PsRvbGAoswWKeEStK+A/WXoh1UXbHEyQIDAQABoyww KjAaBgNVHREEEzARgQ9sbHNvdXNhQHVhbGcucHQwDAYDVR0TAQH/BAIwADAN BgkqhkiG9w0BAQQFAAOBgQCee996SyMsQgWwQUrnHsmltoIMnkkLuWvWfWwq 3fqe8ZLpfvXvFg6Z52EtPZ8vlzp41KM1HQErW2dMe2DyUfbhaUqqNQBvf67V G8STIA+83VEKFK2njzIKpwLXOOjL0estNpcrE1azR/MTfvvu3adO6j5syXd6 pfm4elI2W0yLMzCCAvwwggJloAMCAQICAwcgpDANBgkqhkiG9w0BAQQFADCB kjELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UE BxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRp ZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBS U0EgMjAwMC44LjMwMB4XDTAyMDQwMjEzNDYxNloXDTAzMDQwMjEzNDYxNlow QTEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEeMBwGCSqGSIb3 DQEJARYPbGxzb3VzYUB1YWxnLnB0MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8A MIIBCgKCAQEArq+CLmsIQV5pSRtuNd9sptT22gTUwt0UReWfSlCTApnNcGDQ CiS8nluhr5AWbJWhhIVHQETSKWlT+y09KsYf7AeW1zBQWSUJjhpCDYd8n+T0 SxFl24ZZJhZQ57kVJ7iNzJ7WPYQGk06zoRWgtnFcvVuA1az0vhwWHNk8+1Ja CTeWlwjPRptJZ78CNiN2prAoEoI9m7/jUW6iTJmpNinzkIa1qpKEdPrCQM/d huk6JDl4qmiQ2a87I/aiRJCPtTBIl/Zt2Vjde5Br2qR8pWisjaoVl9ntJJvn i9clXJGk/uO4iwza7IL2K6PsRvbGAoswWKeEStK+A/WXoh1UXbHEyQIDAQAB oywwKjAaBgNVHREEEzARgQ9sbHNvdXNhQHVhbGcucHQwDAYDVR0TAQH/BAIw ADANBgkqhkiG9w0BAQQFAAOBgQCee996SyMsQgWwQUrnHsmltoIMnkkLuWvW fWwq3fqe8ZLpfvXvFg6Z52EtPZ8vlzp41KM1HQErW2dMe2DyUfbhaUqqNQBv f67VG8STIA+83VEKFK2njzIKpwLXOOjL0estNpcrE1azR/MTfvvu3adO6j5s yXd6pfm4elI2W0yLMzCCAzgwggKhoAMCAQICEGZFcrfMdPXPY3ZFhNAukQEw DQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0 ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3Rl IENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMg RGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBD QTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNv bTAeFw0wMDA4MzAwMDAwMDBaFw0wNDA4MjcyMzU5NTlaMIGSMQswCQYDVQQG EwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRv d24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2Vy dmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjgu MzAwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAN4zMqZjxwklRT7Sbngn Z4HF2ogZgpcO40QpimM1Km1wPPrcrvfudG8wvDOQf/k0caCjbZjxw0+iZdsN +kvx1t1hpfmFzVWaNRqdknWoJ67Ycvm6AvbXsJHeHOmr4BgDqHxDQlBRh4M8 8Dm0m1SKE4f/s5udSWYALQmJ7JRr6aFpAgMBAAGjTjBMMCkGA1UdEQQiMCCk HjAcMRowGAYDVQQDExFQcml2YXRlTGFiZWwxLTI5NzASBgNVHRMBAf8ECDAG AQH/AgEAMAsGA1UdDwQEAwIBBjANBgkqhkiG9w0BAQQFAAOBgQAxsUtHXfkB ceX1U2xdedY9mMAmE2KBIqcS+CKV6BtJtyd7BDm6/ObyJOuR+r3sDSo491BV qGz3Da1MG7wD9LXrokefbKIMWI0xQgkRbLAaadErErJAXWr5edDqLiXdiuT8 2w0fnQLzWtvKPPZE6iZph39Ins6ln+eE2MliYq0FxjGCAycwggMjAgEBMIGa MIGSMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYD VQQHEwlDYXBlIFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2Vy dGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWls IFJTQSAyMDAwLjguMzACAwcgpDAJBgUrDgMCGgUAoIIBYTAYBgkqhkiG9w0B CQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wMjExMjAwOTQ0NTNa MCMGCSqGSIb3DQEJBDEWBBSvAbcAh9z9pOKKgitzAh+JdRWHKDBSBgkqhkiG 9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG 9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDCBrQYLKoZIhvcNAQkQ AgsxgZ2ggZowgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENh cGUxEjAQBgNVBAcTCUNhcGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYD VQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNlczEoMCYGA1UEAxMfUGVyc29uYWwg RnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDByCkMA0GCSqGSIb3DQEBAQUABIIB AFzinonLQGtVgaLjYz34JPUYqKsNG3EHtiB0mipNBBh9aM40nXfdrtkHbIEC RgeEVa4hYlEp8K+3dwppNhDNpEMjozGAwpkHtrRNvKbqKcAKXi8gxTmgKbwD 0MRACJYcWjh+f/+idi15NaNI0RWcv7GmLHd4PPbP9k6nNN51ZUuwXOfjqdbJ x6L79TiI+5tf76oIByTks0Mr3HIUPpa6koKctqnC+4Qvlf8Rzzrh4s2TYX/V GGAtTxycH3QfBJnTzJUDUkJehSCxn6Q0txkJ83ecTQJ/O4Qh56BeUWMX39Ys C6x+kv1bc6uLC27X47ozJ9mEWXcz2Pz7JmZlHB4p7hgAAAAAAAA= --------------ms060506010209040204090203--