call function with different select statement - Mailing list pgsql-general

From Allie.Hopkins@gmail.com
Subject call function with different select statement
Date
Msg-id 1147276175.159628.212900@i39g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: call function with different select statement  (John DeSoi <desoi@pgedit.com>)
List 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


pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Feature-Request: Login-Procedure
Next
From: "APSC, Patrick Chee Seng Onn"
Date:
Subject: Creating of User and Database