Re: [GENERAL] Analyzing the types of prepared statements

2013-03-19 Thread Jason Dusek
2013/3/19 John DeSoi : > On Mar 16, 2013, at 8:30 AM, Jason Dusek wrote: >> However, it is not clear to me at this juncture how to get the >> return type for a statement, given its text. Preparing and >> looking it up in pg_prepared_statements will retrieve the >> argument types but not the return

Re: [GENERAL] Analyzing the types of prepared statements

2013-03-18 Thread John DeSoi
On Mar 16, 2013, at 8:30 AM, Jason Dusek wrote: > However, it is not clear to me at this juncture how to get the > return type for a statement, given its text. Preparing and > looking it up in pg_prepared_statements will retrieve the > argument types but not the return type. Wrapping the query i

[GENERAL] Analyzing the types of prepared statements

2013-03-16 Thread Jason Dusek
Hello List, My colleagues and I have some interest in creating an automated PG->Haskell bridge, that will read the PG catalog for a particular namespace or namespaces and generate a Haskell module with functions of appropriate types, creating functions for each stored procedure and simple tuple ty