Received: from newmail.DKFZ-Heidelberg.DE (newmail.inet.dkfz-heidelberg.de [193.174.53.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5QDQMa48922 for ; Tue, 26 Jun 2001 09:26:23 -0400 (EDT) (envelope-from D.Richter@DKFZ-heidelberg.de) Received: from perkeo.inet.dkfz-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by newmail.DKFZ-Heidelberg.DE (8.9.3/8.9.3/DKFZ-8.9.3) with ESMTP id PAA19574; Tue, 26 Jun 2001 15:26:12 +0200 (MET DST) Received: from DKFZ-heidelberg.de (perkeo.inet.dkfz-heidelberg.de [193.174.61.66]) by perkeo.inet.dkfz-heidelberg.de (980427.SGI.8.8.8/DKFZ-8.6.4) with ESMTP id PAA15931; Tue, 26 Jun 2001 15:24:22 +0200 (MDT) Message-ID: <3B388D05.C3919F0F@DKFZ-heidelberg.de> Date: Tue, 26 Jun 2001 15:24:21 +0200 From: "David M. Richter" Organization: German Cancer Research Center X-Mailer: Mozilla 4.7 [en] (X11; I; IRIX64 6.4 IP27) X-Accept-Language: en MIME-Version: 1.0 To: Richard Huxton CC: pgsql-sql@postgresql.org Subject: Re: Plsql Function with error: No space left on device. References: <3B36FB6E.1039F0D4@DKFZ-heidelberg.de> <005601c0fd60$db576740$1001a8c0@archonet.com> Content-Type: multipart/mixed; boundary="------------0B881AE4E842609547765D47" X-Archive-Number: 200106/413 X-Sequence-Number: 3710 This is a multi-part message in MIME format. --------------0B881AE4E842609547765D47 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hallo! The query works, but not right.(apart from the timeaspect) UPDATE image SET seriesoid = r.parentoid FROM image i JOIN relseries_image000 r ON i.chilioid=r.childoid; it does not same than this function: CREATE FUNCTION series_image () RETURNS integer AS ' DECLARE psr_rec record; i integer := 0; BEGIN FOR psr_rec IN SELECT * FROM relseries_image000 LOOP UPDATE image SET seriesoid = psr_rec.parentoid WHERE chilioid = psr_rec.childoid; i := i + 1; END LOOP; IF NOT FOUND THEN RETURN -1; ELSE RETURN i; END IF; END; ' LANGUAGE 'plpgsql'; Only always the same one oid is written in seriesoid(e.g. 0x0) But the part of the query Select * FROM image i JOIN relseries_image000 r ON i.chilioid=r.childoid; works right. Here the Table descriptions: Table "relseries_image000" Attribute | Type | Modifier -----------+-----------------------+---------- chilioid | character varying(80) | parentoid | character varying(80) | childoid | character varying(80) | Indices: indseries_image_child, indseries_image_parent Table "series" Attribute | Type | Modifier ---------------------+------------------------+---------- chilioid | character varying(80) | instanceuid | character varying(64) | number | integer | acquisition | integer | echonumber | integer | temporalposition | integer | seriesdate | date | seriestime | time | description | character varying(128) | contrast | character varying(128) | bodypartexamined | character varying(16) | scanningsequence | character varying(16) | frameofreferenceuid | character varying(64) | Indices: indseries_oid, indseries_uid Table "image" Attribute | Type | Modifier ---------------+------------------------+---------- chilioid | character varying(80) | instanceuid | character varying(64) | imagetype | character varying(64) | number | integer | imagedate | date | imagetime | time | slicelocation | double precision | rows | integer | columns | integer | bitsallocated | integer | path | character varying(256) | relevance | integer | thickness | double precision | spacing_x | double precision | spacing_y | double precision | spacing_z | double precision | tilt | double precision | tableheight | double precision | position_x | double precision | position_y | double precision | position_z | double precision | window_center | integer | window_width | integer | seriesoid | character varying(80) | Indices: indimage_oid, indimage_uid What do I have to change in the Query? Thanks a lot David --------------0B881AE4E842609547765D47 Content-Type: text/x-vcard; charset=us-ascii; name="D.Richter.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for David M. Richter Content-Disposition: attachment; filename="D.Richter.vcf" begin:vcard url;quoted-printable:http://mbi.DKFZ-Heidelberg.de/=0D=0A n:M. Richter;David x-mozilla-html:FALSE org:Deutsches Krebsforschungszentrum;Division Medizinische und Biologische Informatik version:2.1 email;internet:d.richter@dkfz-heidelberg.de adr;quoted-printable:;;Im Neuenheimer Feld 280 url: http://mbi.DKFZ-Heidelberg.de/=0D=0AD-69120 Heidelberg, Germany ;Heidelberg;Germany;; x-mozilla-cpt:;-15296 fn:David M. Richter end:vcard --------------0B881AE4E842609547765D47--