Thread: Problem Using Create Function

Problem Using Create Function

From

"Son Yeo Yiin"

Date:

11 February 2003, 04:07:09

Hi…I’m facing problem when using the create new function wizard in pgAdmin II. When I would like to create a function that return a set of certain data type, I unable to check the checkbox labeled “Return a set?”. It seems like the checkbox doesn’t work. This makes me unable to return a set of value .

May I know what can I do to solve this problem ? Thank you.

With regards,

sonyy

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.406 / Virus Database: 229 - Release Date: 10/21/2002

Re: Problem Using Create Function

From

"Dave Page"

Date:

11 February 2003, 07:31:14

-----Original Message-----
From: Son Yeo Yiin [mailto:sonyy@epedas.com]
Sent: 11 February 2003 06:08
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Problem Using Create Function

Hi…I’m facing problem when using the create new function wizard in pgAdmin II. When I would like to create a function that return a set of certain data type, I unable to check the checkbox labeled “Return a set?”. It seems like the checkbox doesn’t work. This makes me unable to return a set of value .

May I know what can I do to solve this problem ? Thank you.

Hi,

Currently that checkbox is read-only I'm afraid. In order to create a function that returns a set you will need to enter the SQL manually.

I hope to reslve this in a future release.

Regards, Dave.