| From: | "E(dot)J(dot) Moloney" <emoloney(at)moloneyodeaassociates(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Upgrade 8.3 |
| Date: | 2008-04-18 18:10:48 |
| Message-ID: | 862013306.951208542222540.JavaMail.javamailuser@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am running the following query
update tempportfwdconnectiona set srcid=interface.objectid from
interface where tempportfwdconnectiona.hostid=interface.host and
tempportfwdconnectiona.spantreeport=interface.stpport
For application reasons the spantreeport in one table is a text field
and an integer in the other.
I am getting a cast error when I run this query which did work 8.2x, I
can't make both fields the same type is there any work around any body
can suggest.
I tried creating a cast but the interface function text_int no longer
exists.
Regards
E.J. Moloney
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-04-18 18:15:09 | Re: In the belly of the beast (MySQLCon) |
| Previous Message | Geoffrey | 2008-04-18 17:54:52 | Re: In the belly of the beast (MySQLCon) |