New function - hostmask - Mailing list pgsql-patches

Hi,

Have (by necessity) copied and altered the existing 'netmask' function
in postgresql to perform 'hostmask' style duties.

A diff against v7.3.2 is attached.

The patch affects three files:

  postgresql-7.3.2/doc/src/sgml/func.sgml - Updated list of network
functions with a simple example
  postgresql-7.3.2/src/backend/utils/adt/network.c - The bulk of the new
'hostmask' routine.
  postgresql-7.3.2/src/include/catalog/pg_proc.h - Addition of function
'hostmask' into pg_proc

Note that I arbitrarily chose 2311 as the OID (in pg_proc) as it was
unused (although not guaranteed to be the lowest unused value).

Would appreciate any feedback on this (first submission to postgresql
and all),

Cheers,

   -Greg

--


begin 666 postgres-hostmask.diff
M9&EF9B M<B M=2!P;W-T9W)E<W%L+3<N,RXR+6]R:6<O9&]C+W-R8R]S9VUL
M+V9U;F,N<V=M;"!P;W-T9W)E<W%L+3<N,RXR+V1O8R]S<F,O<V=M;"]F=6YC
M+G-G;6P*+2TM('!O<W1G<F5S<6PM-RXS+C(M;W)I9R]D;V,O<W)C+W-G;6PO
M9G5N8RYS9VUL"51H=2!*86X@,C,@,3(Z,C,Z,30@,C P,PHK*RL@<&]S=&=R
M97-Q;"TW+C,N,B]D;V,O<W)C+W-G;6PO9G5N8RYS9VUL"51H=2!&96(@,3,@
M,3<Z-3,Z,38@,C P,PI 0" M-#DY-"PV("LT.3DT+#$S($! "B )/&5N=')Y
M/CQL:71E<F%L/C(U-2XR-34N,C4U+C \+VQI=&5R86P^/"]E;G1R>3X*(" @
M(" @(" \+W)O=SX*(" @(" @(" \<F]W/@HK"3QE;G1R>3X\9G5N8W1I;VX^
M:&]S=&UA<VL\+V9U;F-T:6]N/B@\='EP93YI;F5T/"]T>7!E/BD\+V5N=')Y
M/@HK"3QE;G1R>3X\='EP93YI;F5T/"]T>7!E/CPO96YT<GD^"BL)/&5N=')Y
M/F-O;G-T<G5C="!H;W-T;6%S:R!F;W(@;F5T=V]R:SPO96YT<GD^"BL)/&5N
M=')Y/CQL:71E<F%L/FAO<W1M87-K*"<Q.3(N,38X+C(S+C(P+S,P)RD\+VQI
M=&5R86P^/"]E;G1R>3X**PD\96YT<GD^/&QI=&5R86P^,"XP+C N,SPO;&ET
M97)A;#X\+V5N=')Y/@HK(" @(" @(#PO<F]W/@HK(" @(" @(#QR;W<^"B )
M/&5N=')Y/CQF=6YC=&EO;CYN971W;W)K/"]F=6YC=&EO;CXH/'1Y<&4^:6YE
M=#PO='EP93XI/"]E;G1R>3X*( D\96YT<GD^/'1Y<&4^8VED<CPO='EP93X\
M+V5N=')Y/@H@"3QE;G1R>3YE>'1R86-T(&YE='=O<FL@<&%R="!O9B!A9&1R
M97-S/"]E;G1R>3X*9&EF9B M<B M=2!P;W-T9W)E<W%L+3<N,RXR+6]R:6<O
M<W)C+V)A8VME;F0O=71I;',O861T+VYE='=O<FLN8R!P;W-T9W)E<W%L+3<N
M,RXR+W-R8R]B86-K96YD+W5T:6QS+V%D="]N971W;W)K+F,*+2TM('!O<W1G
M<F5S<6PM-RXS+C(M;W)I9R]S<F,O8F%C:V5N9"]U=&EL<R]A9'0O;F5T=V]R
M:RYC"4UO;B!397 @(#(@,3(Z-#<Z,#0@,C P,@HK*RL@<&]S=&=R97-Q;"TW
M+C,N,B]S<F,O8F%C:V5N9"]U=&EL<R]A9'0O;F5T=V]R:RYC"51H=2!&96(@
M,3,@,3<Z,C$Z,3D@,C P,PI 0" M-C Y+#8@*S8P.2PT-B! 0 H@"5!'7U)%
M5%523E])3D547U H9'-T*3L*('T*( HK1&%T=6T**VYE='=O<FM?:&]S=&UA
M<VLH4$=?1E5.0U1)3TY?05)'4RD**WL**PEI;F5T"2 @("II<" ](%!'7T=%
M5$%21U])3D547U H,"D["BL):6YE= D@(" J9'-T.PHK"BL)9'-T(#T@*&EN
M970@*BD@<&%L;&]C*%9!4DA$4E-:("L@<VEZ96]F*&EN971?<W1R=6-T*2D[
M"BL)+RH@;6%K92!S=7)E(&%N>2!U;G5S960@8FET<R!A<F4@>F5R;V5D("HO
M"BL)365M4V5T*&1S="P@,"P@5D%22$124UH@*R!S:7IE;V8H:6YE=%]S=')U
M8W0I*3L**PHK"6EF("AI<%]F86UI;'DH:7 I(#T]($%&7TE.150I"BL)>PHK
M"0DO*B!)="=S(&%N($E0(%8T(&%D9')E<W,Z("HO"BL)"75N<VEG;F5D(&QO
M;F<@;6%S:R ](#!X9F9F9F9F9F8["BL**PD)+RH**PD)("H@3VYL>2!S:&EF
M="!I9B!T:&4@;6%S:R!L96X@:7,@/" S,B!B:71S("XN"BL)"2 J+PHK"BL)
M"6EF("AI<%]B:71S*&EP*2 \(#,R*0HK"0D);6%S:R ^/CT@:7!?8FET<RAI
M<"D["BL)"65L<V4**PD)"6UA<VL@/2 P.PHK"BL)"6EP7W8T861D<BAD<W0I
M(#T@:'1O;FPH;6%S:RD["BL**PD):7!?8FET<RAD<W0I(#T@,S(["BL)?0HK
M"65L<V4**PD)+RH@1V\@9F]R(&%N($E05C8@861D<F5S<R!H97)E+"!B969O
M<F4@9F%U;'1I;F<@;W5T.B J+PHK"0EE;&]G*$524D]2+" B=6YK;F]W;B!A
M9&1R97-S(&9A;6EL>2 H)60I(BP@:7!?9F%M:6QY*&EP*2D["BL**PEI<%]F
M86UI;'DH9'-T*2 ](&EP7V9A;6EL>2AI<"D["BL):7!?='EP92AD<W0I(#T@
M,#L**PE605)!5%1?4TE:15 H9'-T*2 ](%9!4DA$4E-:"BL)"2L@*"AC:&%R
M("HI("9I<%]V-&%D9'(H9'-T*2 M("AC:&%R("HI(%9!4D1!5$$H9'-T*2D*
M*PD)*R!I<%]A9&1R<VEZ92AD<W0I.PHK"BL)4$=?4D5455).7TE.151?4"AD
M<W0I.PHK?0H@"B O*@H@("H@0V]N=F5R="!A('9A;'5E(&]F(&$@;F5T=V]R
M:R!D871A='EP92!T;R!A;B!A<'!R;WAI;6%T92!S8V%L87(@=F%L=64N"D]N
M;'D@:6X@<&]S=&=R97-Q;"TW+C,N,B]S<F,O8F%C:V5N9"]U=&EL<R]A9'0Z
M(&YE='=O<FLN8RYO<FEG"F1I9F8@+7(@+74@<&]S=&=R97-Q;"TW+C,N,BUO
M<FEG+W-R8R]I;F-L=61E+V-A=&%L;V<O<&=?<')O8RYH('!O<W1G<F5S<6PM
M-RXS+C(O<W)C+VEN8VQU9&4O8V%T86QO9R]P9U]P<F]C+F@*+2TM('!O<W1G
M<F5S<6PM-RXS+C(M;W)I9R]S<F,O:6YC;'5D92]C871A;&]G+W!G7W!R;V,N
M: E3=6X@3F]V(" S(# U.C0Q.C(R(#(P,#(**RLK('!O<W1G<F5S<6PM-RXS
M+C(O<W)C+VEN8VQU9&4O8V%T86QO9R]P9U]P<F]C+F@)5&AU($9E8B Q,R Q
M-SHR-#HS-B R,# S"D! ("TR,S4S+#8@*S(S-3,L."! 0 H@1$530U(H(G-H
M;W<@861D<F5S<R!O8W1E=',@;VYL>2(I.PH@1$%402AI;G-E<G0@3TE$(#T@
M-S,P("@@('1E>'0)"0D)4$=.4U @4$=5240@,3(@9B!F('0@9B!I(#$@,C4@
M(C@V.2(@(&YE='=O<FM?<VAO=R M(%]N=6QL7R I*3L*($1%4T-2*")S:&]W
M(&%L;"!P87)T<R!O9B!I;F5T+V-I9'(@=F%L=64B*3L**T1!5$$H:6YS97)T
M($])1" ](#(S,3$@*" @:&]S=&UA<VL)"0E01TY34"!01U5)1" Q,B!F(&8@
M="!F(&D@,2 X-CD@(C@V.2();F5T=V]R:U]H;W-T;6%S:R M(%]N=6QL7R I
M*3L**T1%4T-2*")H;W-T;6%S:R!O9B!A9&1R97-S(BD["B!$051!*&EN<V5R
M="!/240@/2 Q-S$S("@@(&EN970)"0D)4$=.4U @4$=5240@,3(@9B!F('0@
M9B!I(#$@.#8Y("(R-2(@('1E>'1?:6YE=" M(%]N=6QL7R I*3L*($1%4T-2
M*")T97AT('1O(&EN970B*3L*($1!5$$H:6YS97)T($])1" ](#$W,30@*" @
M8VED<@D)"0E01TY34"!01U5)1" Q,B!F(&8@="!F(&D@,2 V-3 @(C(U(B @
M=&5X=%]C:61R("T@7VYU;&Q?("DI.PI/;FQY(&EN('!O<W1G<F5S<6PM-RXS
G+C(O<W)C+VEN8VQU9&4O8V%T86QO9SH@<&=?<')O8RYH+F]R:6<*
`
end