| From: | "Allie(dot)Hopkins(at)gmail(dot)com" <Allie(dot)Hopkins(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | call function with different select statement |
| Date: | 2006-05-10 15:49:35 |
| Message-ID: | 1147276175.159628.212900@i39g2000cwa.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm working the Cisco ASC for wireless authentication and I'm having
problems getting the ODBC results in a format the ASC server
understands. I created a function that returns basic information for a
given user. The ACS server issues the following command :
select CSNTExtractUserClearTextPw2('cstest')
This results in the following:
(0,0,"CS Test Account","No Error",clearpass123)
It just does not like this format.
I noticed when I issue:
select * from CSNTExtractUserClearTextPw('cstest');
I get:
csresult | csgroup | csacctinfo | cserror | cspsswd
----------+---------+-----------------+----------+----------
0 | 0 | CS Test Account | No Error | tiger123
This could be how the ACS server wants it, but I can't get this result
format (multiple columns) from the issuing command coming from the ACS
server.
Does anyone know what format "recordset" really means?
Allie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-05-10 15:50:24 | Re: Getting relation/attribute names from inside UDT input/output function |
| Previous Message | pgaio | 2006-05-10 15:12:15 | how do i unsubscribe |