X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx2.hub.org [200.46.204.254])
	by postgresql.org (Postfix) with ESMTP id 457E511F6C1F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 20 Apr 2006 04:37:13 -0300 (ADT)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Score: -0.817
X-Spam-Level: 
X-Spam-Status: No, score=-0.817 required=5 tests=[BAYES_00=-2.599,
	DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_WHOIS=1.447, HTML_50_60=0.134,
	HTML_MESSAGE=0.001]
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024)
	with ESMTP id 1FYcuDHHyfWd
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 20 Apr 2006 04:37:10 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from web33514.mail.mud.yahoo.com (web33514.mail.mud.yahoo.com
	[68.142.206.163])
	by postgresql.org (Postfix) with SMTP id 55FD111F6C49
	for <pgsql-sql@postgresql.org>; Thu, 20 Apr 2006 04:37:09 -0300 (ADT)
Received: (qmail 83454 invoked by uid 60001); 20 Apr 2006 07:37:08 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=EpZyflJZGKBQYqtk/X7nLXwQuwnRicuLMD7qF7JZA7WJjcULKGyvzeWTbsWKq/aLQXhx3lcQtdOnTRPgIEjl72IeR2A53uQd+8gFFBOYGS9D1tiFec4HjvWoYlrUeYbhv9I/+IvxEEmZqAx0lhZw/da+S4o43JKZYcO9n0kvj0M=
	;
Message-ID: <20060420073708.83452.qmail@web33514.mail.mud.yahoo.com>
Received: from [222.124.227.199] by web33514.mail.mud.yahoo.com via HTTP;
	Thu, 20 Apr 2006 00:37:08 PDT
Date: Thu, 20 Apr 2006 00:37:08 -0700 (PDT)
From: Mariya Yuniarti <mariya_yuniarti@yahoo.com>
Subject: ask syntax sql to get length of field
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-963241340-1145518628=:81761"
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200604/134
X-Sequence-Number: 24943

--0-963241340-1145518628=:81761
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Here Question :

I have table A with structure :

        Number         Character(20),
       Description   Character(50)

I want to get length of field Number (20)

What is syntax sql to get length of field ?

thx

		
---------------------------------
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
--0-963241340-1145518628=:81761
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Here Question :<br><br>I have table A with structure :<br><br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  Number&nbsp;&nbsp;  &nbsp;&nbsp;&nbsp;&nbsp; Character(20),<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Description&nbsp;&nbsp; Character(50)<br><br>I want to get length of field Number (20)<br><br>What is syntax sql to get length of field ?<br><br>thx<br><p>
		<hr size=1><a href="http://us.rd.yahoo.com/mail_us/taglines/postman3/*http://us.rd.yahoo.com/evt=39666/*http://beta.messenger.yahoo.com">Yahoo! Messenger with Voice.</a> PC-to-Phone calls for ridiculously low rates.
--0-963241340-1145518628=:81761--