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
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 |