Postgres Pro
Downloads
Home   >   mailing lists

pg_attribute.attlen -1 for varchar e pbchar fields - Mailing list pgsql-sql

From jimmy.olsen
Subject pg_attribute.attlen -1 for varchar e pbchar fields
Date
Msg-id 000201c57b3d$c6e0f420$230a0a0a@ligaone.com.br
Whole thread Raw
In response to SELECT * FROM foo OFFSET -1 LIMIT 1  (Markus Bertheau ☭ <twanger@bluetwanger.de>)
Responses Re: pg_attribute.attlen -1 for varchar e pbchar fields
List pgsql-sql
Tree view 
Hi listers,   I'm facing a problem getting information from meta tables. The command:
SELECT attname, atttypid, attlen
FROM pg_attribute
where atttypid IN(1042, 1043)

The attlen column always returns -1 for bpchar and varchar columns. the
postgre version is 8.0.1. When I look the tables in pgAdmin the column
lengths are correct. Where can I find the correct column lengths??

Alessandro - Liga One Sistemas
alessandro@ligaone.com.br

pgsql-sql by date:

Previous
From: Roy Souther
Date:
Subject: How can I simply substatue a value in a query?
Next
From: "Sean Davis"
Date:
Subject: Re: How can I simply substatue a value in a query?