How access to array component

From: Cristian Cappo <ccappo(at)cnc(dot)una(dot)py>
To: pgsql-sql(at)postgresql(dot)org
Subject: How access to array component
Date: 2003-07-18 14:52:02
Message-ID: 3F180992.5070400@cnc.una.py
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello
How access to especific array component
of an function with return type _varchar

declaration of my function:

>>> create or replace __function( int2, int2 ) returns _varchar ....

now use the function in SQL and access to the element 1...

>>> select __function(10::int2, 20::int2)[1]
^^^ parsing error.

Thanks.

Cristian Cappo
-------------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Reinoud van Leeuwen 2003-07-18 15:24:52 plpgsql strangeness with select into <variable>
Previous Message Richard Huxton 2003-07-18 14:25:51 Re: How to determine the currently logged on username