X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id DCBA6D1B508 for ; Thu, 25 Sep 2003 18:59:57 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 46507-08 for ; Thu, 25 Sep 2003 15:59:28 -0300 (ADT) Received: from kogut.o2.pl (kogut.o2.pl [212.126.20.60]) by svr1.postgresql.org (Postfix) with ESMTP id F14FBD1B4EB for ; Thu, 25 Sep 2003 15:59:25 -0300 (ADT) Received: from tlen.pl (unknown [80.48.150.10]) by kogut.o2.pl (o2.pl Mailer 2.0.1) with ESMTP id 6CF2B281BF; Thu, 25 Sep 2003 20:59:24 +0200 (CEST) Message-ID: <3F733B0D.5050801@tlen.pl> Date: Thu, 25 Sep 2003 20:59:25 +0200 From: Adam Wieckowski User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; pl-PL; rv:1.5b) Gecko/20030909 X-Accept-Language: pl MIME-Version: 1.0 To: Larry Rosenman Cc: pgsql-sql@postgresql.org Subject: Re: weird(to me) request References: <294260000.1064515888@lerlaptop-red.iadfw.net> In-Reply-To: <294260000.1064515888@lerlaptop-red.iadfw.net> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms070501050302040904090004" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/312 X-Sequence-Number: 15290 This is a cryptographically signed message in MIME format. --------------ms070501050302040904090004 Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: quoted-printable U=BFytkownik Larry Rosenman napisa=B3: > I have the following rows (in addition to others): > > acct_num text, > master_acct_num text, > > > These are in the same table. > > What I want to enforce is that if the master_acct_num field is NOT=20 > NULL (it can be NULL, and > that's fine), that the value appears in some row as acct_num.=20=20 > acct_num has a unique index on it, so that's fine. > > I'm not sure how to do this.... > > Thanks! > > LER > > select case when master_acct_num is null then acct_num else master_acct_num end from table; did you mained somethink like this ? --------------ms070501050302040904090004 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 AQAAoIINAzCCAo0wggF1oAMCAQICAwEAITANBgkqhkiG9w0BAQUFADA+MQsw CQYDVQQGEwJQTDEbMBkGA1UEChMSVW5pemV0byBTcC4geiBvLm8uMRIwEAYD VQQDEwlDZXJ0dW0gQ0EwHhcNMDIwNzEyMTYzMTUzWhcNMTIwNzEyMTYzMTUz WjBDMQswCQYDVQQGEwJQTDEbMBkGA1UEChMSVW5pemV0byBTcC4geiBvLm8u MRcwFQYDVQQDEw5DZXJ0dW0gTGV2ZWwgSTCBnzANBgkqhkiG9w0BAQEFAAOB jQAwgYkCgYEApe96WfQxXJ+0MtKgWSvkqNfHGr+3a1KyfEomDpQw1bJLfNfn iHC/+BXpU0ho7gDr2HZpvhxmBvffETwdImfgJOu71xSed+70VjnLumjIzbgM LvATnXOXkoAdGPF+PtyzmH7oLWmWvJqxEPB4rdMixPVAXFPSfuD5pFRnnJmf I2UCAwEAAaMTMBEwDwYDVR0TAQH/BAUwAwEB/zANBgkqhkiG9w0BAQUFAAOC AQEAJQ0uGk5oCtGIJlL7f98zextv2a7QQQrTjZVLwuvXO05iyVifONstgB+6 8jV15HLJ+qdGQU60ydrQNsv49j1yXl6wpCv6gCSKTNJeLtDE+3p2OWpGrHbh 6djVzD/bw5YDMu3pVNrN55Dk+/YH4eV7bQvuQ/8eCQzYtQzAAPYZNegyuM1p g1X45Ij/xt3xJ3bSYDQ0LMqp2kNxN25Y7939SiU42VL7QNjJejD9oRUYYGT7 MboVvEF4nUGDYrmtYe11FIj4hESwy1mZn2OncRqx140k8d7IRzWkDNKpA7PY EulCvLliTdm39mAZ7xps8tCEL8ecAwh+4fAHWgQ+g4CBtTCCBTUwggSeoAMC AQICAwKJSzANBgkqhkiG9w0BAQQFADBDMQswCQYDVQQGEwJQTDEbMBkGA1UE ChMSVW5pemV0byBTcC4geiBvLm8uMRcwFQYDVQQDEw5DZXJ0dW0gTGV2ZWwg STAeFw0wMzA5MTYxODAwNTFaFw0wMzEyMTUxODAwNTFaMGgxCzAJBgNVBAYT AlBMMRcwFQYDVQQKEw5Qcml2YXRlIFBlcnNvbjEYMBYGA1UEAxMPQWRhbSBX aWVja293c2tpMSYwJAYJKoZIhvcNAQkBFhdhZGFtLXdpZWNrb3dza2lAdGxl bi5wbDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAPi+2A8dDahn u85Cu5Pu8QbVn2O+YCkrkUHyzbel6aFGIRVZmvQpBAUatPLNOHUSto574U74 0Tc1YCEQYttaUTczZ68hNHinH2sK29+a/jZnLlRh4D99B9h2a4mJPQsflO0Y pQ1gidmWvIh/Q+cmATcWOA3L9lTMG2HgMGGJGtE8AQnHrMhiU8dZHLglccdt gqNPqgJYeI9ubTgp43mTZx9pPSub2PS6/3E7EDr6OCSw820InmAE6Ml3Bk6U iGyTW4XIMHuLoqbqwJFT7/4AyJ5zq3PCOOhfg8IVg3gWLcKLzrroW9WWo8lW yXSWdRFZiZaoY1DnyTCfDcmKdBusfVUCAwEAAaOCAowwggKIMCIGA1UdEQQb MBmBF2FkYW0td2llY2tvd3NraUB0bGVuLnBsMAkGA1UdEwQCMAAwMAYDVR0f BCkwJzAloCOgIYYfaHR0cDovL2NybC5jZXJ0dW0ucGwvY2xhc3MxLmNybDAx BggrBgEFBQcBAQQlMCMwIQYIKwYBBQUHMAGGFWh0dHA6Ly9vY3NwLmNlcnR1 bS5wbDCCAfAGA1UdIASCAecwggHjMIIB3wYKKoRoAYb2dwICATCCAc8wJAYI KwYBBQUHAgEWGGh0dHA6Ly93d3cuY2VydHVtLnBsL0NQUzCCAaUGCCsGAQUF BwICMIIBlzAZFhJVbml6ZXRvIFNwLiB6IG8uby4wAwIBARqCAXhVc2FnZSBv ZiB0aGlzIGNlcnRpZmljYXRlIGlzIHN0cmljdGx5IHN1YmplY3RlZCB0byB0 aGUgQ2VydHVtIENlcnRpZmljYXRpb24KUHJhY3RpY2UgU3RhdGVtZW50IChD UFMpIGluY29ycG9yYXRlZCBieSByZWZlcmVuY2UgaGVyZWluIGFuZCBpbiB0 aGUgQ2VydHVtClJlcG9zaXRvcnkgYXQgaHR0cHM6Ly93d3cuY2VydHVtLnBs L3JlcG9zaXRvcnkuICBUaGlzIENQUyBpcyBhbHNvIGF2YWlsYWJsZQpieSBt YWlsIGF0IFVuaXpldG8gU3AuIHogby5vLiA3MC00ODYgU3pjemVjaW4sIEty b2xvd2VqIEtvcm9ueSBQb2xza2llaiAyMSwgClBvbGFuZC4gQ29weXJpZ2h0 IChjKSAxOTk4LTIwMDMgVW5pemV0byBTcC4geiBvLm8uIEFsbCBSaWdodHMg UmVzZXJ2ZWQuMA0GCSqGSIb3DQEBBAUAA4GBAFglDLE+2t0zFYJe0bN1rpa2 15/jpo+51rFO77PRLejgKK+2LlNL/kqRZCwc1BVlVEhiwsQ+LGpuHnU5myjK hek4DQdyQBNLI8zypHMjXXF/MW57yyod84Ltnse9eYCC9kTcy0m0uZREDvxk PNnEeIsMRvxLKb5eXzGX54alT3v7MIIFNTCCBJ6gAwIBAgIDAolLMA0GCSqG SIb3DQEBBAUAMEMxCzAJBgNVBAYTAlBMMRswGQYDVQQKExJVbml6ZXRvIFNw LiB6IG8uby4xFzAVBgNVBAMTDkNlcnR1bSBMZXZlbCBJMB4XDTAzMDkxNjE4 MDA1MVoXDTAzMTIxNTE4MDA1MVowaDELMAkGA1UEBhMCUEwxFzAVBgNVBAoT DlByaXZhdGUgUGVyc29uMRgwFgYDVQQDEw9BZGFtIFdpZWNrb3dza2kxJjAk BgkqhkiG9w0BCQEWF2FkYW0td2llY2tvd3NraUB0bGVuLnBsMIIBIjANBgkq hkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA+L7YDx0NqGe7zkK7k+7xBtWfY75g KSuRQfLNt6XpoUYhFVma9CkEBRq08s04dRK2jnvhTvjRNzVgIRBi21pRNzNn ryE0eKcfawrb35r+NmcuVGHgP30H2HZriYk9Cx+U7RilDWCJ2Za8iH9D5yYB NxY4Dcv2VMwbYeAwYYka0TwBCcesyGJTx1kcuCVxx22Co0+qAlh4j25tOCnj eZNnH2k9K5vY9Lr/cTsQOvo4JLDzbQieYAToyXcGTpSIbJNbhcgwe4uipurA kVPv/gDInnOrc8I46F+DwhWDeBYtwovOuuhb1ZajyVbJdJZ1EVmJlqhjUOfJ MJ8NyYp0G6x9VQIDAQABo4ICjDCCAogwIgYDVR0RBBswGYEXYWRhbS13aWVj a293c2tpQHRsZW4ucGwwCQYDVR0TBAIwADAwBgNVHR8EKTAnMCWgI6Ahhh9o dHRwOi8vY3JsLmNlcnR1bS5wbC9jbGFzczEuY3JsMDEGCCsGAQUFBwEBBCUw IzAhBggrBgEFBQcwAYYVaHR0cDovL29jc3AuY2VydHVtLnBsMIIB8AYDVR0g BIIB5zCCAeMwggHfBgoqhGgBhvZ3AgIBMIIBzzAkBggrBgEFBQcCARYYaHR0 cDovL3d3dy5jZXJ0dW0ucGwvQ1BTMIIBpQYIKwYBBQUHAgIwggGXMBkWElVu aXpldG8gU3AuIHogby5vLjADAgEBGoIBeFVzYWdlIG9mIHRoaXMgY2VydGlm aWNhdGUgaXMgc3RyaWN0bHkgc3ViamVjdGVkIHRvIHRoZSBDZXJ0dW0gQ2Vy dGlmaWNhdGlvbgpQcmFjdGljZSBTdGF0ZW1lbnQgKENQUykgaW5jb3Jwb3Jh dGVkIGJ5IHJlZmVyZW5jZSBoZXJlaW4gYW5kIGluIHRoZSBDZXJ0dW0KUmVw b3NpdG9yeSBhdCBodHRwczovL3d3dy5jZXJ0dW0ucGwvcmVwb3NpdG9yeS4g IFRoaXMgQ1BTIGlzIGFsc28gYXZhaWxhYmxlCmJ5IG1haWwgYXQgVW5pemV0 byBTcC4geiBvLm8uIDcwLTQ4NiBTemN6ZWNpbiwgS3JvbG93ZWogS29yb255 IFBvbHNraWVqIDIxLCAKUG9sYW5kLiBDb3B5cmlnaHQgKGMpIDE5OTgtMjAw MyBVbml6ZXRvIFNwLiB6IG8uby4gQWxsIFJpZ2h0cyBSZXNlcnZlZC4wDQYJ KoZIhvcNAQEEBQADgYEAWCUMsT7a3TMVgl7Rs3WulrbXn+Omj7nWsU7vs9Et 6OAor7YuU0v+SpFkLBzUFWVUSGLCxD4sam4edTmbKMqF6TgNB3JAE0sjzPKk cyNdcX8xbnvLKh3zgu2ex715gIL2RNzLSbS5lEQO/GQ82cR4iwxG/Espvl5f MZfnhqVPe/sxggLeMIIC2gIBATBKMEMxCzAJBgNVBAYTAlBMMRswGQYDVQQK ExJVbml6ZXRvIFNwLiB6IG8uby4xFzAVBgNVBAMTDkNlcnR1bSBMZXZlbCBJ AgMCiUswCQYFKw4DAhoFAKCCAWkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEH ATAcBgkqhkiG9w0BCQUxDxcNMDMwOTI1MTg1OTI1WjAjBgkqhkiG9w0BCQQx FgQUWAlvh8yN+VKPub6A+vKfZEAy9nQwUgYJKoZIhvcNAQkPMUUwQzAKBggq hkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4D AgcwDQYIKoZIhvcNAwICASgwWQYJKwYBBAGCNxAEMUwwSjBDMQswCQYDVQQG EwJQTDEbMBkGA1UEChMSVW5pemV0byBTcC4geiBvLm8uMRcwFQYDVQQDEw5D ZXJ0dW0gTGV2ZWwgSQIDAolLMFsGCyqGSIb3DQEJEAILMUygSjBDMQswCQYD VQQGEwJQTDEbMBkGA1UEChMSVW5pemV0byBTcC4geiBvLm8uMRcwFQYDVQQD Ew5DZXJ0dW0gTGV2ZWwgSQIDAolLMA0GCSqGSIb3DQEBAQUABIIBAERFzoSF 4rXaQVVJqVWH385U/OiwtWYLtB3c2CDAk3vVJRHQr6frpiv7oJRfdphghj7z FV9PLz80OB46zGISmb084ndOrITJaCsCxRSaeYvP/EzM18/r4AjOWSt200NW l8s7v6umgCt0YUZvwbXvF2MflhOEbj4ShnIDNhgsOQ8ZVXw7wF1dvobvsU8B Q5xI8tJoGfRbZ0wZd+n5LwZfY9fDKEbe9Pwg23BIpkai9avflP2Y/x8A0rh4 xwj3gh/LU4tdxq5GIIBxgdyQ0Pgx36MMq5iTO1ziQKdEkDjZHO72+2heisHa TjOlf4yyen1+7i1KCZMPBsEmk3gT+PWMlMoAAAAAAAA= --------------ms070501050302040904090004--