Skip site navigation (1) Skip section navigation (2)

Re: Array as parameter for plpgsql function

From: David Pratt <fairwinds(at)eastlink(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Array as parameter for plpgsql function
Date: 2005-07-13 15:09:13
Message-ID: 12CC07A3-F3B0-11D9-97E3-000A27B3B070@eastlink.ca (view raw or flat)
Thread:
Lists: pgsql-general
argh!!!  It was telling me I had an error in select statement. Thanks 
Tom!

Regards
David

On Wednesday, July 13, 2005, at 11:08 AM, Tom Lane wrote:

> David Pratt <fairwinds(at)eastlink(dot)ca> writes:
>> CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
>> 	DECLARE
>> 	test_array ALIAS FOR $1;      -- alias for input array	
>> 	BEGIN
>> 		return array_upper(test_array,1)
>> 	END;	
>> ' LANGUAGE 'plpgsql';
>
>> SELECT create_record_test(ARRAY[ARRAY['A','test one'],ARRAY['B','test
>> two']]) AS output;
>
> Works fine for me, once I add the semicolon you forgot:
>
> 		return array_upper(test_array,1);
>
> 			regards, tom lane
>
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that 
> your
>        message can get through to the mailing list cleanly
>

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2005-07-13 15:28:28
Subject: Re: Strange memory behaviour with PGreset() ...
Previous:From: marcelo CortezDate: 2005-07-13 15:07:07
Subject: fts error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group