Re: Determine length of numeric field

In Oracle you never have to cast, in Postgres it's pretty common.<br /><br />See the doc on String Operators and
Functionsalso:<br /><a
href="http://www.postgresql.org/docs/8.4/interactive/functions-string.html">http://www.postgresql.org/docs/8.4/interactive/functions-string.html</a><br
/><br/><div class="gmail_quote">On Tue, Feb 15, 2011 at 3:48 PM, Tony Capobianco <span dir="ltr"><<a
href="mailto:tcapobianco@prospectiv.com">tcapobianco@prospectiv.com</a>></span>wrote:<br /><blockquote
class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
I'maltering datatypes in several tables from numeric to integer.  In<br /> doing so, I get the following error:<br
/><br/> dw=# \d uniq_hits<br />    Table "support.uniq_hits"<br />   Column   |  Type   | Modifiers<br />
------------+---------+-----------<br/>  sourceid   | numeric |<br />  hitdate    | date    |<br />  total      |
numeric|<br />  hitdate_id | integer |<br /> Indexes:<br />    "uniq_hits_hitdateid_idx" btree (hitdate_id),
tablespace<br/> "support_idx"<br /> Tablespace: "support"<br /><br /> esave_dw=# alter table uniq_hits alter sourceid
typeint;<br /> ERROR:  integer out of range<br /><br /> Sourceid should not be more than 5 digits long.  I'm able to
perform<br/> this query on Oracle and would like something similar on postgres 8.4:<br /><br /> delete from uniq_hits
wheresourceid in (select sourceid from uniq_hits<br /> where length(sourceid) > 5);<br /><br /> I haven't had much
luckwith the length or char_length functions on<br /> postgres.<br /><br /> Thanks.<br /> Tony<br /><font
color="#888888"><br/><br /> --<br /> Sent via pgsql-sql mailing list (<a
href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br/> To make changes to your subscription:<br /><a
href="http://www.postgresql.org/mailpref/pgsql-sql"target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br
/></font></blockquote></div><br/><br clear="all" /><br />-- <br />Peter Steinheuser<br /><a
href="mailto:psteinheuser@myyearbook.com">psteinheuser@myyearbook.com</a><br/>