From: L J Bayuk <ljb220@mindspring.com>
To: Bshrivastav@esri.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Is there a way to describe precision and scale
Date: Tue, 8 Jun 2004 20:08:19 -0400 (EDT)
Message-ID: <200406090008.i5908J7O000262@mindspring.com> (raw)
In-Reply-To: <491DC5F3D279CD4EB4B157DDD62237F401ADE475@zipwire.esri.com>
Brijesh Shrivastav wrote:
>
> Thanks for the comments. They were very helpful.
>
> However, I am still not sure about the second problem
> i.e. of describing the prepared statement. Does some
> other api exposes it? Can I use some sql command to get
> around it (I couldn't find any)? any other ideas?
Since libpq doesn't expose it, no API based on libpq will let you at it.
There are a few non-libpq interfaces, but I doubt any have this advanced
feature. My pgin.tcl doesn't.
If your prepared query has a parameter which you can use to efficiently
select 0 (or a small number of rows), you might be able to use that as a
'dummy' query just to get column information. This is similar to the trick
of using "SELECT ... LIMIT 0" to get an empty result set just so you can
look at the column info.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ljb220@mindspring.com, Bshrivastav@esri.com
Subject: Re: Is there a way to describe precision and scale
In-Reply-To: <200406090008.i5908J7O000262@mindspring.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox