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: | Raw Message | Whole Thread | 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 |