Re: arrays as pgsql function parameters

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?

http://archives.postgresql.org

In response to

Responses

Browse pgsql-general by date

  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

Browse pgsql-sql by date

  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