[pgsql-jp: 38187] 配列で複合型の指定の仕方について

[shigemiya]

$BHK5\$G$9!#(B
$B$$$D$b$*@$OC$K$J$C$F$*$j$^$9!#(B

$BG[Ns$GJ#9g7?$r07$$$?$$$N$G$9$,!"$I$&$b>e<j$/$$$+$::$$C$F$*$j$^$9!#(B
$BG[Ns$KJ#9g7?$r%;%C%H$9$k>l9g!"L@<(E*$K7?JQ49$9$kMM$K=q$$$?$N$G$9$,!"(B
$B7?JQ49$,$G$-$J$$$H%(%i!<$GJV$5$l$F$7$^$$$^$9!#(B
$B%(%i!<!'(Bcannot cast type record to test

$BG[Ns$GJ#9g7?$r;XDj$7$?$j!";2>H$7$?$j$9$k>l9g$I$N$h$&$K;XDj$9$l$P(B
$B$h$m$7$$$G$7$g$&$+!)$465<x4j$$$^$9!#(B

$B4D6-$O(BPostgreSQL8.1.5$B$r;HMQ$7$F$^$9!#(B
--------------------------------------------------
--$B%F!<%V%kDj5A(B
CREATE TABLE test
(
  id integer,
  name integer
) 
--------------------------------------------------
--$B%U%!%s%/%7%g%sDj5A(B
--$BC1=c$KG[NsMWAG$N(B1$BHVL\$rJV$9!#(B
CREATE or REPLACE FUNCTION array_show(anyarray)
RETURNS anyelement AS $$
DECLARE 
   result ALIAS FOR $0;
BEGIN
    result := $1[1];
    RETURN result;
END;
$$ LANGUAGE plpgsql;
---------------------------------------------------
--$B<B9T(B
select array_show(ARRAY[(1,2)::test,(1,3)::test,(1,4)::test]);

===================================================
$B7k2L(B(pgAdmin$B-7$G<B9T(B)
$B!!(BERROR: cannot cast type record to test
$B!!(BSQL$B%9%F!<%H(B:42846
$B!!>\:Y(B:Input has too many columns.


$B0J>e$G$9!#$h$m$7$/$*4j$$$$$?$7$^$9!#(B
--------------------------
 shigemiya<acid_rain ＠ hotpop.com>