On Apr 25, 2005, at 4:53 AM, Piotr Filipczuk wrote:
How to determinate column size in query in libpq? Especially when column is declared for exapmle as varchar(64). PQfsize return -1 which mean that is variable and PQfmod returns 68.
68 - 4 is the correct size for varchar(64). There is 4 bytes of overhead included in the return value.
If you are trying to do something like column formatting where you need to know the longest length, maybe take a look at the psql source and see how it works there.
John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
