Re: arrays as pgsql function parameters

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Joseph Syjuco <joseph(at)asti(dot)dost(dot)gov(dot)ph>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: arrays as pgsql function parameters
Date: 2002-06-07 13:33:02
Message-ID: Pine.LNX.4.44.0206071632130.14271-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Fri, 7 Jun 2002, Joseph Syjuco wrote:

> 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

Well, it depends on the code :)
Is it C? pg/plsql??

>
> -----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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Syjuco 2002-06-07 14:08:50 Re: arrays as pgsql function parameters
Previous Message Wim 2002-06-07 13:28:47 HELP! Cannot access table!!!!

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Cass 2002-06-07 13:44:45 select failure
Previous Message Achilleus Mantzios 2002-06-07 11:23:33 Re: arrays as pgsql function parameters