Appendix - Design and Use of Relational Databases in Chemistry - page 180

Table A.2 Average Atomic Weights for
Molecular Weight Computation (Continued)

Smarts Weight Symbol

[#77] 192.22 Ir

[#78] 195.08 Pt

[#79] 196.97 Au

[#80] 200.59 Hg

[#81] 204.38 Tl

[#82] 207.20 Pb

[#83] 208.98 Bi

[#84] 209.00 Po

[#85] 210.00 At

[#86] 222.00 Rn

[#87] 223.00 Fr

[#88] 226.03 Ra

[#89] 227.03 Ac

[#90] 232.04 Th

[#91] 231.04 Pa

[#92] 238.03 U

[#93] 237.05 Np

[#94] 244.00 Pu

[#95] 243.00 Am

[#96] 247.00 Cm

[#97] 247.00 Bk

[#98] 251.00 Cf

[#99] 252.00 Es

[#100] 257.00 Fm

[#101] 258.00 Md

[#102] 259.00 No

[#103] 260.00 Lr

[*;h1] 1.01 H1

[*;h2] 2.02 H2

[*;h3] 3.03 H3

[*;h4] 4.04 H4

[*;h5] 5.05 H5

[*;h6] 6.06 H6

Create Function amw(character varying)
Returns Numeric As $EOSQL$
Select sum(weight*count_matches($1,smarts)) From amw;
$EOSQL$ Language SQL;