Contrib of an array based type to postgres - Mailing list pgsql-general

From Thomas Fricke
Subject Contrib of an array based type to postgres
Date
Msg-id 14078.15436.63995.150750@teddy.baeren.de
Whole thread Raw
List pgsql-general
Hello Folks,

as a result of some work with postgres  I wrote the attached example,
which may be useful as contrib.

------
Tschoe,

    Thomas

----
Pursuant to US Code, Title 47, Chapter 5, Subchapter II, Sec. 227,
any and all unsolicited commercial e-mail sent to this address is
subject to a download and archival fee in the amount of $500 US.
E-mailing this address denotes acceptance of these terms.


--------
begin 644 threadid.tar.gz
M'XL("%L^_C8"`W1H<F5A9&ED+G1A<@`!)`K;]1^+"`!;/OXV`@/M6GUOV[P1
MS[_6ISBT!1JG\KN3/$WB`&GKIPV0IEGL;!BZPI`E6B8JBXI(Q?6Z?/?=D9(L
M.W&?/NG+NDV'5)+)>R%Y/QZ/9-4T9H['O<;6CR/H-O=W=V$+H+6_VZ(W4C-]
MIS]@;V]_O]O9;^ZWD:W5WNUNP>[63Z!$*B<&V%)3,7/D9KY8"+7UOT<J\_];
MYR.;\(#]`!NM9G.OV]WL__WVGO%_9W^OTR7_=YK-YA8T2___<'IL/:Y<"*G\
MF`W^<@9J$3$)$Q'#Z>#%.3BAAQ^#<^`>"Q6?<!;+ND4R3TZ]`\@P8]]`J]Z"
MUO/GOS6:OS5:^]#L''1V#YI=D&[L1-$"^I\B>&)9%^\&P]>7_<'I^<NSJU?]
M00]JIXU$QHV`CQN1+Z^#!@_=(/%85B%CMQ$Y[D?'9[(Q>'=U^;(_:$2FQ<A>
MN]FK=S53*F=93A`<0(;KNA1@685?A2IA50(/:B_DU,&2<8`VQ8I@@7.IHJC!
MM2JN"S4?:N^@-KDX?0E/MM>[6*U4H.8692P>(NC66\FE#/%M5=+:%:%E/9CA
M$JX3I`,V$UX2,&EIOS`QP?<#YO]E_^35V_X/P=@?S/]6M]E>QG\]_]OM=J><
M_S^#?L>I[L#?V!@\+MU$2B["%'9P"B%C'O.008I8P20)747U%!]2'NY)VXI9
MA),1(P3Q2G"G#F(8MELUC\_`B6-G404Q`8X,OHX@UG#*M$X>^B"G(L%Y.&;@
MB9`A%P1<L=@)0,0>BY&[9L@R/NH=@V0!<Q7LP"06L[0ITK##>`&*>X<6/@R^
M_N4*-!PJ@$Q1K?8L_[(^MVY3/L4^*6CA%Y;9;;MSFY>U.UF9W;K-RUJFK%O@
MZR)?9T5?A_1M[T(LYK)J+5M@6>_&-UPD,EC8V`/JM^J^_Z`C,,YU''/LE!2A
MCDON5'"7U>&-F+,;%FN!6+-9H0#)9Q$RL4^.?E-W8SY.R!N)I!'6+C"QO0[#
M:2)M].T4O:<$CCEP!=9L@6,ZJ<-5B,Y52>@HEC4LD3BJ4QQA=!VJ8A`*!3*9
M3+C+<5AM="2JLU)]R*VEQ@E'IV9B'H_18<$B<QAY/XE=9L-\RMTIS$7\D7G6
MG`4!^GM`"N<.N@P5+KN#<MCCM)LV`844345$/Q3,L(]CW=Q)$J"D)<6,C86W
MT'@CY,#O,7<_(O<+%@<HC@O6<VOK_YKR^+]<GWYV_-_#I"^+_[NX`E#^UVFU
MROC_,ZBQ4_M>9,$._A42'5U4`1A$S.48SK/UPR284TPN`XI.A94DC0849#S,
M+$.]GI#2E'0@D^E:TFG74Y,O1;2(N3]5L.U6]:RV867&&SYBI87'A,-E:[*8
M%CFXR*%NBBI9K8-KT0*B6-QP6@G-RF=B8MWHHVB*T0<C4\A<)J43+RAL96DL
M<LL\#.KH)YU9%OXD9)DLRI,Z'357XKP3DG:*CQ)T>*RG=I>A$(=28N1C(0Y:
MS&^HF5F4Y7(<4N)HEI4\=)HN8$I-W35.RX8E7T70,$93J1*/HT:,EL2'UK^4
M?#<2Q0/9T)KJ4[U]^)+4&/-Z%GJ9E*>,Y&<:?&GKTEO,EU&#QL"Z2QO6XVR4
MCUSJ8'UZ7"B2RN-BO2A&Q%'9LO!1UK+Z]%&QV'4P"Q=^(WU3[=W*R!\9PRNB
MIC]R(5W'G;)525,W8S/]L5HGE8C1*8V)MUH^F?GQ?5K2<5ZQC1NIZ+JAG[7)
MFGY3-V98@7X=ISTV,PU.!H/7YQ5XU,.RQ@Z<A"D@"%QZ1H@@$'.:L)3'Q3@S
M$!QQXJHD9@=FHA^%XX5B\KA2J>$4P!&",)F-,7M`E.F:C`WS0LVTK,82%DH]
M'=,9J*VG`I/`\8W:L5[HY4?BTJ4IA]&(#)+_4Z.:.3J04`^<3[S`-L)>L/@8
M6?4'C$42>C1I,Z&\*:F,@UW$KGCH\F.H88C"W`@G)\UXG<B@TW""4+7&I/5]
M0ZKIPT@D"O0H8XM`X;Y;9DFC<46>@CLZ0\>^.)D#:1;&#-U$H0[,%$@U46Z%
MN;J)PED$X!1Q*+BDJC'FS1Q%4>=[]HL&JJ'CJ<?&B>]3&S#-%6GZ&-)68.:X
ML0`<:[TK02!/0@0KC$:O^B^N7H]&%J;6&7R';V@'>_IJ]/+MQ?9-R[YIVX&R
MV;7MJRI\_@>RZB4#Z`M@)VKUMG7!3A5.+B]'KTZ&)Z.+X26*5NV<J;V)J5T]
M))Y4;<H?MGJ:Z_3M@-2\;W[(-(7M0DV;:L!.:VR>:QH+@8Y,0O3U4OMD&]7V
MPG;ULQ$P]3UV?9@JZ(4M_7E+#Q9(9LJUX-%2+I<,U&%6DLNFTD9^7<!?$6@7
M!>@?NG";]YJ'P(\@Q.>S9]6\!5'K/?]P%+7Q6<VU:BA"WHQEDY<BQYE()>7V
MER.2EN3C=+N,8)>7)W_7_G=:ME/T_RHZL+IJ;SMM?`0*'^P:'\A6/;0>4VLL
M[8C\Q&?DSJ+M$YH:0UI$=Q!<4/S9MHWGT)SY0*/F`W5:GW/D?0WPO@)W!'J#
MNHV@VXBY'')&21%PJ=HEW-;0M@0;82V%VAK2[@"MB#.#FB7*[H"LB+&<^7Z`
MW8>O._#*3=T/KB*VC*%59"&PX&N@E4JMH.6+",/5;V)9&F252BX6J"+&P%D%
M&3AF>-?;@0LPLR<.=M(\J]3L.ZK9@U4O]=^KF5T_1+-I[Q^H]MDWJJ;'_9K5
MPS4O]1O5Z[I#]HU>+*BV_C/[?\S0?^[^O]O9VTWW_\UNI[-'^_^]O?+\]Z<0
MYF*U6O$&R!4>RR^`9-TR#/JZAS:3!(^-USV[:]<]=,H9"-S;/RU<6N`XLX89
M[883T09IU*IWZAV](TSO,AJN<$7C'FR*IX=6VJ33,,*<F));C-;T6=C08R$E
MD>8L5=')YH%NC(MZ5%J>*85MJW)Z?G$U7%Y'0R_-NGEH6Y5W5\.5VMXR);=)
M=-B_/#\Y.^N?OQZ^@4H/_GIR>7KRXJR/E?VS_MO^^;`@2J>\5C7O!!U'W#@Q
MG0/KU9AAUH[[)"57VIL?O!=7B^S;SDOS)<WHLBJX<_N.(V]5`B?T$SHU>.J2
M'S:WCOW*K<-%ZQ=NG?]+CYW_2^,N_!7&SDSL<S'7(4A$+':4B&4=X%PHNJZ8
M`UU,9,<<D1,[,Z;H=%`)74/B:>73M*N9EJ<8GF<S#&_FT))^F%LWC$5UT(>"
M),WI.-!UTJN8!::H$Q:ST&5T.[=@"I(P.U[-VV=3U"3A.0\".OFC2R7N<KJT
MR9CG4T:C37MT-&^C!V*ZB`)/S,-Z,6!E6N&(HFO`)KC&^AC]<N^@3^B\=KT4
MS8?,UY(]..XA6Q0+EWD)=K97C'XZA-XQUOL6:QN-L7N-_4E;%?)5HE+1WIKQ
MHXW6V?6]UH__K/F"K4VF_/L[>OQP2QL=Z&]PX,-M;305LL)R2_\[`K^V2BJI
MI))**JFDDDHJJ:222BJII))**JFDDDHJJ:222BJII))**JFDDDHJJ:222BJI
6I)+^>^G?TG%*,0!0```!AN0&)`H`````
`
end

pgsql-general by date:

Previous
From: Charles Tassell
Date:
Subject: Re: [GENERAL] Determining if "in a text set"
Next
From: Herouth Maoz
Date:
Subject: Re: [GENERAL] using Oids to retrieve a row