Received: from ambr.mtholyoke.edu (ambr.mtholyoke.edu [138.110.1.10]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f04LNs724517 for ; Thu, 4 Jan 2001 16:23:54 -0500 (EST) (envelope-from ron.peterson@yellowbank.com) Received: from yellowbank.com (IDENT:rpeterso@pagoda.mtholyoke.edu [138.110.30.68]) by ambr.mtholyoke.edu (8.9.1/v001215-0259) with ESMTP id QAA05243; Thu, 4 Jan 2001 16:24:18 -0500 (EST) Message-ID: <3A54EA02.F1E1EFD8@yellowbank.com> Date: Thu, 04 Jan 2001 16:24:18 -0500 From: Ron Peterson Organization: Yellowbank X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.4.0-test9 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-hackers@postgresql.org CC: marc@milestonerdl.com, peter_e@gmx.net Subject: md5 c code Content-Type: multipart/mixed; boundary="------------9DFD0D2540AF5103A05AAF8E" X-Archive-Number: 200101/71 X-Sequence-Number: 2743 This is a multi-part message in MIME format. --------------9DFD0D2540AF5103A05AAF8E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I've attached a bit of c code to do md5 checksums on text. There's nothing too original here, this was mostly just ripped from rfc1321, with some driver code added for PostgreSQL. Also a Makefile and a test schema. Sorry if this isn't the right place to post such a thing. I had just noticed a question on the pgsql-sql list about this, so I thought, what the heck, I'll try to contribute something. Please note that this code is copyright RSA Data Security, Inc. What kind of complications that causes for distribution, I have no idea. It says unlimited distribution, so seems o.k. to me, but what do I know. The copyright notice is preserved in the code and included in the README. This function accepts text as input. I.E. - pg_md5(text). Since postgres.h defines both text and bytea to be the same thing (typedef struct varlena), does that mean this function should also accept binary input? -Ron- ron.peterson@yellowbank.com --------------9DFD0D2540AF5103A05AAF8E Content-Type: application/x-gzip; name="pg_md5.tar.gz" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="pg_md5.tar.gz" H4sIAKzcVDoAA+xceXPcNrLPv+KnQMmpmGOPRjxAckayvavorpKPleT3XtbJ uniAIyYcckJyZMmJ89m3GweP0VByEtvJqxLL1hBgd6N/jUajAR7P/Z9YnKTs q894GKZhuNT4yjBsapq09csPkxruV4ZnWY7pUMdwgN42TPMrYnxOpdSxKCu/ IOSrYs4qVpR5H91d1/+fHg9IkWcjiS375zVL0/xd4Gc/jcJ8pj0gFvTPBv6z iTHZopMtwyQ7zzVtd5c8JZuLstgMkmxzGoba+c7p4f451EYsWEy1B3U5TjI/ 1fYOTnYOz6C48b9+mpKNqXawVPPS0s7qqniehGSjvPALFmnPvzt+sXvyem+f XzrmzaZ56KebSRami4h1K8si3JznZTUtWPmzKK6ka9HI69DSyfG3vJWTFmGa BN2KFie/ls5/1rQkZj8T/WtdAB8MOe6Btvb8u10F62tdgB5oLC3Z0qU9dSmL klgD278q8h9ZWG2UcxYmMdgDPHXKqlLT5tO3s8gZlfkWkae5tva1vrs7ADnC iHD2hGzk5Ot/1uQNdUjgbwg/0zQP/HR0geXRRSNDKSbOlfWFzFCJfUBeV0ma VNeNYpU/Lbe0NYa/5BE08AikQm0BlTjOwveXsVICyqPpe/JcRiAklSzVVQV/ y/CCzXxNG706evniuy0SpszPNP4XpG0UM/LoNyQGsY9A0BIhKzT5u4oY/uTY RE7CvGDaXz0K/7pDOcDnbEPEf9ob/x085/GfeibF+G95nnEf/7/EsfmIHJ68 /HbnZHRENsjp2c7p/gGpruesJH4WwejIwD5ZBYN5EwZ8EmcRi8lbwfL26K32 AMpJxtpVGsh8dfry/OX5d68gYpcX+SKNSMBIySpS5SQH8iTm4vMsvcbz6oJB U7M5hIGClIv5PC8gmhASL7KwSvKMQHxZzFhWkXmRVznol2TTkXYObHGOMxYU yQwCSdluGVTzFylv08BWkopc+CXJ8or4acH86BqaCBjLiAARkXdJdUF2G1Xi FOLYSEPwCnsjv8beatLQHsjwjUZ4efzifP9USgeDkimDeASBfJ4nGXgTNzQK x18UvsjKZIqKhBcYqKSAbS7tNZxbLVnVu5wE1xUj7/IiWikELF9UBFoSvI0Y 2hIT54viDjlpDtZVYuh208FvT47PzklS1vaL2BzhAzn02UX+rm2aFpkf5Jds pB1DGyUSN1RDdIWsLb1g1aLISu4iaVJWQ5LDafEuKcGLKuhAReBnhM3mMBkh Vd1nvf3FpetIO+Ac0HE4JffS6IO6a8UvASs0Xo/N/dVj+Y8cfN7/zG3cEf8t x3Pq+G85NsZ/KNzH/y9xgBM/33N48L+AiIgxD3OxOC+wfne0ywcSjvjdfH5d JNOLiuiQIpqTiblhDXHGIHt+5ZMzFi4KyAWH5DgLR2QX4msFQx3pRmQnTTXO W8JwLVlxyaKRpp0kIctgGFeYhc2v+YywwPIFxIoyj6t3kP1j3JgWMAWBMAj+ l0kEJ9WFX+Hoh2tQzirIjjGsiCix3qcTACLPWVn6U7axl0wZDPqddJoDxcVs HQIcwWXIDNQuEh9OUG6e8WBWgNoxK1gWYrGjnwYXeYWaq1rAoNZPIcdU+gNQ nKRqoGDu5NKvkksefH8qa4AaB1guwgt5gRuig3SdM8N5XOQzjlvB1u6ETfph a7fBlhrjRAlaAdA+S4upOMuBf44dnlU+Ci0xnwhZwaWzBOO4hlJnrIAJD4gC sZzI4yUf4DaGBGKRLNNoNQ26rJ9dk7lfVEm4SGFUzxcFrNTYiBxX2Be1+6yD /ZJyXcPpPl9UhF2hliU2k8zmKVoYRGKn8XZQ6k9Jhi4LGQf0G2QQ0MMlmUHw wMQGpiCfT2xoTCAGb07gsmRFhWp1ozzkiYwv0pos2oRGFQYxazVpFvRcJ8eS ZU0MWjRmxa6qUXvSLqtiEVbkF5gYxUwP4a1ib+gP2+TuA+RycqLvfLu7N0C5 SkyYL7LqjdWIAdpsMQsgYAC0IKnKIZnl0SLNifUflxI9LQMIJQVOnVxMN7UJ FjE41hv3Nr2ghSSbQ/cIYhTzAXG/3T3/P0hCLvMkwuJxBnldK2HQdUlDHg0G 2zXZ63mEyBpC0KlFOlzOvVoVkPq0JR3gur7bYpf3jen+MCQdLdo5g+jFv0nC IPYBPm8bt8//FnWoxed/6hge9Tyc/+379d+XOUQogXlerP5WRXPuyhCjxQwS iRnEVzPIfX5wnx/c5wdfOD+Qu9nravduvVXHV3Trckiq3RuZz5+DziWcz0gB uEAlJVFmGGemSbxWySKm1SraxGxfpcRqXbVM4rRKFpm0SsBJW0XgNJqibZLW RRsaNVtFYHVbRWC1myI1SesiBdaWXAqsLZUosJqahhlOEhI1mzcm6czoIuuB vGk5McCcBWf0tpj9LMyjTm6xnBJAOiEkrsgr2pL22E1JNxn7MpQlaG9nbBZC 3OwAk3tKQ1KffIQU3LlbLQV4bkpQIroKv9rZ2zt+cYgGJE95hmpcjY0h+XP/ UMyflfGnxGgfxI7YwZAcDskRD97HPCAHfglGwPCqYr/aS5QueaBfDQnExPcD MKl+NSDfEP16MCC/QvE3UXw/GAxq+sMV9O8l/TUv/dahP2rTA/l/UDz+fd8i Om4TictI+6sShtig63fO99+e7B+cQ+TAJUJJrkjK4opkPPnv4mqRo/BMqfvk CdEzqS8Unz0jum1tYJVs5wCNiFY8Ggo7HpNKjU85Q2Akg+CVRSUxhwQyDFuQ 0pF2msuwiVMDg7CKCT+f/vwoSvgVmGEhlF/iTnLBcJt3IViW+uVA94ckGJJw SKIhAQiwuvHDAfmFfK8R3R+Qx0/JAYAIBkOih/gnAliPCaKCv3zEDnTg2FYM Tzs21KEKmMpBQwASQRwvkg9Njx9+hCaHX0KTo6OP0OToS2hyfPwRmhx/Tk3U AjyBpSfkRMl74UPkWzZNxE40Xs3nrOAXhuQd5D6Y0/gkY+/qdTv3uc4yVpeX BhpfAddLSFn9MWt4tXSWLNgEhlpZ3HgmFvIGhuClOhPrjG2Ns5/kfgRp2hQC WBdlc0tohErytX0tSGw2cOHGletRx7INc/smhWjqisVh5AfjyQoKS1BMxoEf hTFbQWELCtOwLYd67rbW9EuQ5uFPZCFW/HU3jDAfgm5YsLqLuosaaKPVZ5AN Qg7H70/4Gb/noMiFfBF2eCMy+2107Hat3HpQnTsU2xry54Rln7a3edVSqsBb ulNes+HC7XdDFt4CUjqvFgYSUpZNqwvMZ5dk/aIti0ILRAzGL2bAKFMTvrfL 4zJr7y9d44wzyyPiUqEX5wQH0Du5h67f9HOYZWycG40r+2CgmpBd0t3BkpJj skoMRgAZOpQNcD6zB7L3yJNbr98Ya48fb98clubqdgCCNRG6S1MBcrDEhjCD AtWksrB+meHSokpm6OywtMnBk4OUNWMWYTYNPFWCBzwxI630UcKrc77BN7XS chePKwGJck0h/VuJ3FYSGwX17mAekiWZAizhs72ekFq9bZJACHdtsHbjiQka zaWqI25v6BvO9yb5QTWhPIlHvg/wn98H5FdErTDut2ITsmAzWMol/IYouje3 5ZKxfo+panWGQnuFaiMZtCMaf5aonmf2MftZGcJWTToiMol1tIhfag8H4td7 VuTJe7V8Xxm+xH6nLpjqnhqsCjSCBvc/b93WXdJDBZo/GgBvznZLm80wtt+M f9i+EYBU9IlawefMv1wdF+QiTxd73d2BOyTjOrS8gokTNw0g1XRcGbNaw+6P xK2YDyGhJ/IKIU9A/oD8g+jQjIwEA7JFdNMy6vK28M4bM5BciynwtfI7c7yB r4K4HjAYRAyJ8Kb+oPb2G/KEURojnFXIJ24mJFmno5Udl/ypHqCmW0v5N3dO fHAEjMW3wZKsXgo0Nm0tUpuhV6sGa7QShEBf6sqxBp2xJZZp3XXGqAmmpYQB ZAyfWBEzmhgivXsJugTDaeVQWbofs2r8cHJ+V0Rr7uD40OUqsQKJdcmEUliX LChFdcmG0hUfh2hKuauAazGZukC0VEY+xcUUMYUpD2BV00mu3xBs9MyEtZZx FXmu71MPuhkZWyxAWXMBi8lZLGRh49ALPHBUzmI1LEK+4AIWi7PYyGJRy/CM KBAsdsNSa+VzFpuzUGQJzSAKGWOChfZioQ2W2PFCI/ZjweL0YnEaLIDcC13L FyxuLxa3weKPbYO6pi1YvF4sXoMljqg7cQxTsIx7sYwbLO5kbEzGkeyXSS+W SYNlHFAaewq+afSBMY0GTAyHEwRSM9PsQ2OaDZrxxAkjL5A9Y1p9cEyrBSeY GKZpWZLH7sNj2g2eOJqMPXMiDW3SXjy01TmuN6H2WOnm9OJxGjx0ElBjbCkb cCdojyMJ8PDwRn9xo1jC91yTWY6rAHoNz1KHcU+yOMDQoEZgU0PyjBueJYCi HTGSXIc5vqOUnTQ8S+7HO9niANkkcEPPl05uGb14nAZP5FqxaTiR5DH78Ahn Qjx8mFOTOrLDLKsXj9Pgica+ydyxxGPZvXhoC48X2XEQyrFh0V48kwaPZTIz jJgKWk4vHtrqH9v2DC9SPG4fHhG2BJ6YRo4RjT3J4/XiGTd4qOP4JmXK1uM+ PGJwCDz+hNlsYjiSZ9Lrb1aDJw5Z7NuxtJtt9OLxGjyu58aGFU0kj9mHRwx2 gWccWT4Nx9LfbGt5QMlOPjpa7YC2KSOTb0+oHFB2i2cJIDekLSKg55lx7Uw2 bXhWDShbAIwmkVtHJttpeJYAcsewZTxnjj02Qsnj9uIxGzw+DRjzKZU8Xi8e 2uChQcTC2FfGH/fhER0m8MRuENDAlUHFnvTiMRo8AQtgPHmShxp9eIQDCjzW eBJ4LJSDg5q9eIwGD/N90/Ji6RjU6sVjN3giymLbGEtHp3YfHhFYEQ8abjw2 IzU4KO3tn0mDB9yARoYtbU2dPjzC0SUeNwomE6bacXv9zWnwmLFveaEahNTr xWM1/RNSP3RcV7UzXh5QEuDx8epMj4oBRa2JZSkHpJOGZ6nDuDNR4YC25cfx REYzx2h4Vk3BVEzBAYxa21c8ZsOzBJAbhYoBFU5svza+Y/XhEcYXeFzHCZxJ KGcbx+7FYzd4xrERhuFEDnaH9uIxGjywyI9j6sno7Di9eMwGz9gZUyeKZCBy 3N7+GbfwxP7YY1Rlr14fHuFMAk/MrJC5TA5cZ9yHRwwO2T+2YVLblH7gTPrw iMEu8FBmjE3Tl3hcoxcPbfmb59geG0tbu2YvHrPBE0S2H1u2dHTX6sVjNXgs P/IiK5BrC9fu7Z9Jg4cFYzeyJwoPlQOq3ut+/JT423WF2MILmgqLV4RNhc0r ok+xyL3qLG+vmnWtWGSXcpNK7ifiVkOOexO8rrPyHIzITlkucLcQ1v4kwZcv fDJbpFUyTxluhNCbK161khcS623ttN7RXtqFFnTb7dWw3JlesdGc4pbMqj3j H7nh6o1BwP8j36eDnyeciySPH2MlGJmq7UzR9Jsff+hsvXDkutqB43stcSy3 KxXHY3MVT8P07BkZD3pYrTtZTbeP176T16Id3g+y68Viv+76roSuCwi3+CNd r3YUertedm+ny1felPh8Xd+2Z8Kt2d5XB18QN6K7ldDd/D419Omv9c73Eokl SLDvVgiwxVWL1oPxRV6xLXLK5qkfMrKO+qd5Pl8XrxvhzbTILyIin9ZI4vZu Pcaansc6+o2vXjzqWF9V/l6zL9kct9sbY980svLQ3w8eQ9sN8D0Po9TYL/10 we7EjkA45afFrevCkweisYF0Mz7SZHMf/g4P+d5yqBeCP2cbd73/Y8vnfx0T kgCbP//rGdb9879f4tjcvPUDAHC59QUA09oyjC3DJa+ef+RTiJ2KcBS2a9RL 9B26J2VV4LudF8+apxKf7/HbQvL2UKuaPzMhn51oVcu7E/V9itYlcS9L3dTi AWo+BdVIhM+tFoTPassxdz5FBp6SHbErvTuPPRqKH4Ib6nhz4ZF83V7H99yx IsnIQFvjl5oqjDhrgjEQkLdFGR+Ahrn3jW1DCG24RC1GF141mPvQT6H+Pzun R3unZ/8mj4kNixttbTmy4a1T1ebGs8v0LdZtEMUHOq9J86qbbi0Zy/f0gFgq C2JnQgPeyGNiIv41MTPpCtJwqW3oDB6qOa2keQNlkWM9/N54iE3UaGt9n5IO TqE0drpO1B1WLlJ1fVM9bFRR7Uon0Im6AdUWga13O1tRyQ6QKGf5JdNJV1OO TpSHuAfFxcUFY7U9RJV4YbVh5jPlbf6mVLhgV0rOUic9kjTbyqdqUu5nyxOb cLSQ65cXOmlNcKbL5zeCifPaWsizJukBKkM2+JN7FJ+leog9traWxDoJyTPy cPIQGENMv+wJXqjVeJM84slwuK2kkq5UIya/W6BwGxQJBmxdsq3Gnf7u8+9f fZzu7+w938cvbny+Nvj87/bO/7ZJ6+//uJZp8+//OO79/P8ljlsm/7U1rZ77 KTHsLdPdMimf+3cy/iIEa95UyMVHHFpPpJDlN4Uw+rAM36/ArHpRMv5+BXkl 0oCzf52MCDnH1zqWREONuPceJQULq/Qab8LjQy1LdOrVCfGexenBrmlbJgmu yemInMLsjrpUQsvjc+3ED/LCr/LimqsjnzkryFmYsCwU7+D0vL6iaftRIiTJ tCVqvmKDTxjj1x3wBCnmBT6SQ/C7QcpQ1/mi0FTCg0wlzE5JUPhFgqesCrkl YL56yF8Hqr/28xDqsWn1QZ8KMMnP5GBzBYtTMJD4VEKrPSznAX5KiLcGQr7L F1roZ0DlR+LNGSGE7w5wrcufU/wMxgzNkGLuxD9YMS/QVfCBsoffJyu0QAXR kvj0u3hDR1SXassBxJeM1e9nwQwHBKV89qjA7lWU0MbKDhWmUdSapMbvevAv edQdkmRkhZX8kqNi/PFVbWND0+5fW7t/be3+tbXP/NraXz3L3R99x80Y+enb uCv/s+rvvzgUSkBPXc++z/++xLHxiQ6YS2/dSILL7Y0kc8uCfw5+SvKTaaB9 OlF7py9fkYPXL3bPj1++kHkE33iBBfwna+QT6rsLy7jz/dUaa6f7569PX5wR LGk7Z+Th5kU+Y5vKoTcjmOk2YRKB6XxWbs6n+FVL4N5s0k7tZOfF4eudw33y MHz497QA+BcmBBjH+HwqX/wr4hCTRq2h0NfX8X2viP63nTvXiSCGAQDa8xV0 K7o4l+MaLedyL2eXOAn3ffP17A6CYZEYCrb0q6JxbEuJIs1MEciBM4WqVNLK FgpKEYXCNViNpZ0em/mKGdAlYlUh+RgMsCEq2hOi9h6+zU/cZND4ZkNFwXDW tiaVPXlTMetQACvqNmPyg6lJruTTqHRGTkgmZKdd1NVAjBU8ZDXRLpd6fHJ6 dn5xeXV9c3t3//D49Pzy+tYUYlM5m4weSBerFOaaLHnm6LGASW2h8ZUv/YXF peWV1cHa+sbm1vbOcHdv/+Dw6PcW45s6rPMY6GNRAW1MFLJGzFRddB6ANVO1 QKMHbbOvPDWdUdPeYcnVRq1TMUzORbaUoy4aFCaPcWZmpz/ozw8/j0evNzc7 Og+fv85+BGN3NHFnfHJP/yr1y/J2pv1vvzpLT3t3JptN7czLa6UQQgghhBBC CCGEEEIIIYQQQrTeAXADf4YAeAAA --------------9DFD0D2540AF5103A05AAF8E--