From: JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>
To: 'pgsql-sql@hub.org' <pgsql-sql@hub.org>
Subject: a little conversion problem. . .
Date: Thu, 1 Jul 1999 14:18:44 -0400
Message-ID: <01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com> (raw)
hello all! i thought someone on this list might have trained their brain
cells more than me. . .
i have two tables -- one with a field called autoinv int4 that represents a
service record, and another table with a field vinvnum varchar(20) that
represents a vendor invoice number. if we had a subcontractor perform
service, his/her vinvnum will be the same as the service record number
(autoinv in the other table). i'd like to compare those two fields, and
where they are equal i'd like to update another field (for all practical
purposes, a field in the first table mentioned above with autoinv in it)
with the value of -1. here is what i tried:
update table1 set fieldtobeupdated = -1 where text(table1.autoinv) =
table2.vinvnum;
exhausts memory every time. closes back-end. no way jose' (sorry mr.
soares -- you have to have heard that too many times!). would it work if i
used varchar(text(table1.autoinv))?? or
text(table1.autoinv)=text(table2.vinvnum)? i thought i'd ask here first
before i tried -- if it bombs i bring 20 people and the business to its
knees, and have to re-start postmaster. . .
thanks for any help you can provide! jt kirkpatrick / mpsllc.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: jt-kirkpatrick@mpsllc.com, pgsql-sql@hub.org
Subject: Re: a little conversion problem. . .
In-Reply-To: <01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com>
References: <01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox