Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 96E5B47679A for ; Fri, 7 Jun 2002 10:50:20 -0400 (EDT) Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph [202.90.128.8]) by postgresql.org (Postfix) with ESMTP id 63E3647618E for ; Fri, 7 Jun 2002 09:20:58 -0400 (EDT) Received: from askr (askr.asti.dost.gov.ph [10.10.5.36]) by kitana.asti.dost.gov.ph (Postfix) with SMTP id 82C0A2584B; Fri, 7 Jun 2002 21:18:19 +0800 (PHT) From: "Joseph Syjuco" To: "Achilleus Mantzios" Cc: Subject: Re: arrays as pgsql function parameters Date: Fri, 7 Jun 2002 22:08:50 +0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 In-Reply-To: X-Archive-Number: 200206/67 X-Sequence-Number: 8032 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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Achilleus Mantzios Sent: Friday, June 07, 2002 7:24 PM To: Joseph Syjuco Cc: pgsql-sql@postgresql.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@postgresql.org) > -- Achilleus Mantzios S/W Engineer IT dept Dynacom Tankers Mngmt tel: +30-10-8981112 fax: +30-10-8981877 email: achill@matrix.gatewaynet.com mantzios@softlab.ece.ntua.gr ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org