From: | "Joseph Syjuco" <joseph(at)asti(dot)dost(dot)gov(dot)ph> |
---|---|
To: | "Achilleus Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: arrays as pgsql function parameters |
Date: | 2002-06-07 14:08:50 |
Message-ID: | PAEBJHHLOIKKCIGBMJOLAEEBCAAA.joseph@asti.dost.gov.ph |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
actually i already have and basically the function statments start as
create function test(_int4) returns integer
when i tried to execute the function
select test('{1,2,3,4}');
it didnt spew out errors but it didnt output results either
-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Achilleus Mantzios
Sent: Friday, June 07, 2002 7:24 PM
To: Joseph Syjuco
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] arrays as pgsql function parameters
On Fri, 7 Jun 2002, Joseph Syjuco wrote:
Have a look at the documentation regarding server side programming.
Also you can have as examples the contrib/array and the famous
contrib/intarray package.
> how can i pass and access array parameters to a function
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
--
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
tel: +30-10-8981112
fax: +30-10-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
From | Date | Subject | |
---|---|---|---|
Next Message | Wim | 2002-06-07 14:20:18 | HELP! Cannot access table!!!! |
Previous Message | Achilleus Mantzios | 2002-06-07 13:33:02 | Re: arrays as pgsql function parameters |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2002-06-07 14:20:05 | Re: UPDATE ... FROM vs standard SQL |
Previous Message | Ian Cass | 2002-06-07 13:44:45 | select failure |