Re: arrays (was untitled)

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Madhavi <madhavi(at)zoniac(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: arrays (was untitled)
Date: 2002-09-24 13:51:09
Message-ID: 20020924064806.B92621-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 24 Sep 2002, Madhavi wrote:

> How do I pass an array as an aruments in a postgres function? And how do I
> use it in the function??

Well, I've only got a 7.3devel machine to test, but:
create function f(int[]) returns int as
'select $1[1];' language 'sql';
select f('{3,4}');
seems to work for example.

What are you actually trying to do and in what language?

Browse pgsql-sql by date

  From Date Subject
Next Message Matteo Beccati 2002-09-24 14:20:38 Re: select case problem
Previous Message Tom Lane 2002-09-24 13:26:25 Re: [GENERAL] CURRENT_TIMESTAMP