Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1N41Hx66266 for ; Thu, 22 Feb 2001 23:01:17 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1N41B927004; Thu, 22 Feb 2001 23:01:11 -0500 (EST) To: Ines.Klimann@liafa.jussieu.fr cc: pgsql-sql@postgresql.org Subject: Re: insert values In-reply-to: <20010222135222.A14873@liafa0.liafa.jussieu.fr> References: <20010222135222.A14873@liafa0.liafa.jussieu.fr> Comments: In-reply-to Ines.Klimann@liafa.jussieu.fr message dated "Thu, 22 Feb 2001 13:52:22 +0100" Date: Thu, 22 Feb 2001 23:01:11 -0500 Message-ID: <27001.982900871@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/348 X-Sequence-Number: 1544 Ines.Klimann@liafa.jussieu.fr writes: > I have the following type : > ... > How can I insert a value in this table ? INSERT INTO entiers VALUES('1234') should work fine. BTW, change the "malloc" calls to "palloc" if you don't want to suffer from severe memory leakage problems. Otherwise the code seems OK, though I'd recommend a tad more validity checking in the input routine... regards, tom lane