Postgres Pro
Downloads
Home   >   mailing lists

Thread: Assigning Values to Arrays

Assigning Values to Arrays

From
Zitan Broth
Date:
Greetings All,
 
Running pg 7.3.4 and was reading: http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00018.php .  Basically want to assign values to an array and then a 2d array.
 
However I can't get this to run in properly I get a syntax error (at or near "[") with function listed below.
 
Any suggestions are greatly appreciated :-)
 
Thanks,
Z.
 
btw, is there an user-contributed notes section of the pg documentation I could post a working example too (yeah php developer in the house :-)).
 
Test procedure::

create table test_output(
 output_num_arr numeric[][],
 output_txt_arr TEXT[],
 output_str text
);
 
CREATE OR REPLACE FUNCTION F_TEST(TEXT) RETURNS NUMERIC AS '
DECLARE
 HeaderArray text[] = ''{}'';
BEGIN
 HeaderArray[1] := \'hi\';
 HeaderArray[2] := \'this\';
 HeaderArray[3] := \'is\';
 HeaderArray[4] := \'not\';
 HeaderArray[5] := \'a\';
 HeaderArray[6] := \'test\';
 
 insert into test_output(output_txt_arr) values (HeaderArray);
 insert into test_output(output_str) values (HeaderArray[1]);
 insert into test_output(output_str) values (HeaderArray[2]);
 insert into test_output(output_str) values (HeaderArray[3]);
 insert into test_output(output_str) values (HeaderArray[4]);
 insert into test_output(output_str) values (HeaderArray[5]);
 insert into test_output(output_str) values (HeaderArray[6]);
 
END;
'LANGUAGE 'plpgsql';
 
select F_TEST('a');
select * from test_output;
drop function F_TEST(TEXT);
drop table test_output;
 

Re: Assigning Values to Arrays

From
Oliver Elphick
Date:
On Wed, 2003-10-08 at 11:41, Zitan Broth wrote:
> Greetings All,
>
> Running pg 7.3.4 and was reading:
> http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00018.php .  Basically want to assign values to an array
andthen a 2d array. 
>
> However I can't get this to run in properly I get a syntax error (at
> or near "[") with function listed below.
>
> Any suggestions are greatly appreciated :-)
>

Your function does not have a return statement.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Let no man say when he is tempted, I am tempted of
      God; for God cannot be tempted with evil, neither
      tempteth he any man; But every man is tempted, when he
      is drawn away of his own lust, and enticed."
                                       James 1:13,14

Re: Assigning Values to Arrays

From
Zitan Broth
Date:
But that isn't causing the syntax error .....

From rereading the Post I am certain that I need 7.4 rather than 7.3.4 for
this to work :-)

Thanks for the response.

Z.


> On Wed, 2003-10-08 at 11:41, Zitan Broth wrote:
> > Greetings All,
> >
> > Running pg 7.3.4 and was reading:
> > http://archives.postgresql.org/pgsql-interfaces/2003-09/msg00018.php .
Basically want to assign values to an array and then a 2d array.
> >
> > However I can't get this to run in properly I get a syntax error (at
> > or near "[") with function listed below.
> >
> > Any suggestions are greatly appreciated :-)
> >
>
> Your function does not have a return statement.
>