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/>