X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0688CD1B4FC for ; Wed, 8 Oct 2003 10:43:38 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 31629-03 for ; Wed, 8 Oct 2003 07:42:53 -0300 (ADT) Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by svr1.postgresql.org (Postfix) with SMTP id 3579AD1B50D for ; Wed, 8 Oct 2003 07:42:50 -0300 (ADT) Received: from ptil-138-190-chn.primus-india.net (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 8 Oct 2003 10:42:46 -0000 Message-ID: <016801c38d89$9fed7080$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: "psql" Subject: Possible to have array as input paramter for a function? Date: Wed, 8 Oct 2003 16:17:37 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0165_01C38DB7.B04E5100" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.6 tagged_above=0.0 required=5.0 tests=HTML_40_50, RCVD_IN_OSIRUSOFT_COM X-Spam-Level: * X-Archive-Number: 200310/94 X-Sequence-Number: 15494 This is a multi-part message in MIME format. ------=_NextPart_000_0165_01C38DB7.B04E5100 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear Friends, I am working with Postgres 7.3.4 on RH Linux 7.2 and my windows client is P= gAdmin 3. Is it possible to pass a Varchar[] as a input parameter for a PL/pgSQL func= tion. While I tried it give a error=20 Type "varchar[]" does not exists. Does this is supported in Postgres? Anyone have a link or while paper on handling arrays in functions? Please enlighten me on this. Regards Kumar ------=_NextPart_000_0165_01C38DB7.B04E5100 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Dear Friends,
 
I am working with Postgres 7.3.4 on RH Linux 7.2 and my= =20 windows client is PgAdmin 3.
 
Is it possible to pass a Varchar[] as a input parameter= for a=20 PL/pgSQL function. While I tried it give a error
    Type "varchar[]" does not=20 exists.
 
Does this is supported in Postgres?
 
Anyone have a link or while paper on handling arrays in= =20 functions?
 
Please enlighten me on this.
 
Regards
Kumar

------=_NextPart_000_0165_01C38DB7.B04E5100--