Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT md5(CAST(c.* AS text)) AS md5, c.*
- FROM claims_master c
- MD5(ARRAY[company_id, membid, memb_keyid, lastnm, firstnm, hpcode, option, hpfromdt::text, opfromdt::text, opthrudt::text, pcp, pcp_keyid, birth::text, sex, ethnicity, street, street2, city, state, zip::text, phone, language, rlship::text, othcov::text, othname, field27, option_aid_code]::text) AS hash
Advertisement
