pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




Message-ID: <01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com>
Permalink:  ../01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com/
Also on:    postgresql.org/message-id/01BEC3CC.A2260D20.jt-kirkpatrick@mpsllc.com

 · 

reply

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