call function with different select statement

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

Responses

Browse pgsql-general by date

  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