Hi tom, how to decode the atttypmod field........when i allocate 10 it shows it as 14 n for 20 it shows it as 24.......my problem is not just with varchar........it is for all fields that has variable length .........the same atttypmod returns -1 for integer? am confused........
I want the size allocated for each field i a table whether its a var-length or fixed length........ Shra On Saturday 27 April 2002 20:37, you wrote: > Shra <[EMAIL PROTECTED]> writes: > > [ where to get declared-length info for var-length columns ] > > This is encoded in the atttypmod field (see PQfmod). I'd recommend > using format_type() to decode the info, but if you don't mind possibly > having to change your code from time to time, you could just wire > knowledge of the interpretation of typmod into your code. > > In future, kindly be more selective about the lists you cross-post to. > I generally make a practice of ignoring questions posted to the bugs > list, for example. > > regards, tom lane -- Shra ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster