Larry McGhaw wrote:
4) libpq **cannot** describe the maximum internal data size of a char or
varchar constant!
Example: select '123' from <any table>
This is clearly a bug or serious oversight in libpq that should be
addressed.
The database *knows* this size of the char constant (obviously), and
should report the size via a metadata call, as all other relational
databases do.
What is not clear to me is why it is so important for you to know the
length of a piece of data you are supplying. If it is so vitally
important, you could always cast it, e.g. select '123'::varchar(3)
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
