Using an SRF with VB6

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Using an SRF with VB6
Date: 2005-04-12 18:38:56
Message-ID: 20050412182546.M6458@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,

I have written a set returning function using plpgsql. It works fine on the
database side
DB=# SELECT * FROM interface.func_item_sales('TIE24');
order | company_name | actvt_date | qty
-------+------------------------------+------------+----
12170 | W.E.I. West | 2004-11-30 | 16
12354 | Handling Systems of Maine | 2005-01-03 | 12
12357 | Bemis Company Inc. | 2005-01-07 | 20
12448 | Crown Lift Trucks - LaGrange | 2005-01-11 | 32
12487 | C & S Equipment, Inc. | 2005-01-11 | 4
12557 | Scholtz Equipment | 2005-01-18 | 4

My question ( and feel free to point me to a more appropriate list ) is how
would this be accessed from a user interface written in VB6? We have had
success in accessing views but seem to be hitting a snag when using the
function. What are the column names? How are they determined? From the
type? Does the output need to be aliased in order to access the data? i.e.

SELECT * FROM interface.func_item_sales('item') AS returned_data_set;

Your guidance is appreciated.

Kind Regards,
Keith

Browse pgsql-novice by date

  From Date Subject
Next Message Greg Sabino Mullane 2005-04-13 01:58:15 Re: select top N entries from several groups (Modified by David Orme)
Previous Message Tom Lane 2005-04-12 16:49:37 Re: ask for parts of a user defined types