2013/3/19 John DeSoi <desoi@xxxxxxxxxx>: > On Mar 16, 2013, at 8:30 AM, Jason Dusek <jason.dusek@xxxxxxxxx> 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 in a >> SQL stored procedure which returns record doesn't cause the >> server to infer and store a more specific type. > > You might want to take a look at the extended query protocol here: > > http://www.postgresql.org/docs/current/interactive/protocol-flow.html > > If you send a "parse" (P) messaged followed by "describe" (D), you can > get a row description for the return type without executing anything. Thanks for the tip. I will give that a shot. -- Jason Dusek pgp // solidsnack // C1EBC57DC55144F35460C8DF1FD4C6C1FED18A2B -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
