Accessing an array element from a function - Mailing list pgsql-general

From Mike Nolan
Subject Accessing an array element from a function
Date
Msg-id 200409302223.i8UMNl4G030461@gw.tssi.com
Whole thread Raw
Responses Re: Accessing an array element from a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
This may be mostly a documention issue:

I have a function with two parameters that returns an array: text[].

I want to access just the first element of that array within
my SQL statement.

This doesn't work:

    select myfunc(1,2)[1];

This does work:
    select (myfunc(1,2)[1];

If that's how it's supposed to work, is that documented somewhere?
--
Mike Nolan

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: about "pg_dump " without pompt password
Next
From: Scott Frankel
Date:
Subject: readline install questions