Re: Add value in an Array
От | Jerome Chochon |
---|---|
Тема | Re: Add value in an Array |
Дата | |
Msg-id | 026401c233d8$b7aaece0$80a337c1@pclisi17 обсуждение исходный текст |
Ответ на | Add value in an Array ("Jerome Chochon" <jerome.chochon@ensma.fr>) |
Список | pgsql-general |
Thanks but i want to use only PLPGSQL or SQL. Or perhaps there is a native function in PostgreSQL (like dim_arrays). Someone have another solution ? ----- Original Message ----- From: "Mikail Majorov" <mik@nix.org.ru> To: "Jerome Chochon" <jerome.chochon@ensma.fr> Cc: <pgsql-general@postgresql.org> Sent: Thursday, July 25, 2002 1:47 PM Subject: Re: [GENERAL] Add value in an Array > On Thu, 25 Jul 2002 13:48:58 +0200 > "Jerome Chochon" <jerome.chochon@ensma.fr> wrote: > > > Hi all. > > > > I am a french student working on a PostgreSQL database. > > So i want to create a view which use a fonction (write in PLPGSQL) . > > This function will take a colum from a table (the column is integer[] based) and add a value in the array. > > So i dont find an operator to make this command. > > > > Someone can help me ? > > For example..... > > CREATE FUNCTION add_array(text[], text) RETURNS text[] AS ' > $_[0] =~ s/[{}"]//g; $_[1] =~ s/[{}"]//g; > my %hs = (); > foreach my $c (split(/,/, $_[0])) { $hs{$c} = 1; } > if ($_[1] ne "") { $hs{$_[1]} = 1; } > return "{" . join(",", (keys %hs)) . "}"; > ' LANGUAGE 'plperl'; > > CREATE OPERATOR + (leftarg=text[], rightarg=text, procedure=add_array); > > CREATE FUNCTION del_array(text[], text) RETURNS text[] AS ' > $_[0] =~ s/[{}"]//g; $_[1] =~ s/[{}"]//g; > my %hs = (); > foreach my $c (split(/,/, $_[0])) { $hs{$c} = 1; } > if ($_[1] ne "") { delete $hs{$_[1]}; } > return "{" . join(",", (keys %hs)) . "}"; > ' LANGUAGE 'plperl'; > > CREATE OPERATOR - (leftarg=text[], rightarg=text, procedure=del_array); > > -- > С уважением, > Михаил Майоров > Таганрогский Узел ЭлектроСвязи > +7 8634 362563 > +7 8634 383242 fax only >
В списке pgsql-general по дате отправления: