X-Original-To: pgsql-sql@postgresql.org Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id D17AB475A71 for ; Thu, 13 Mar 2003 20:54:58 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 07A6FD5FA; Thu, 13 Mar 2003 17:55:01 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id D542E5C04; Thu, 13 Mar 2003 17:55:01 -0800 (PST) Date: Thu, 13 Mar 2003 17:55:01 -0800 (PST) From: Stephan Szabo To: Christopher Smith Cc: Subject: Re: date and plpgsql error In-Reply-To: <20030314013736.32799.qmail@web14107.mail.yahoo.com> Message-ID: <20030313175218.K74429-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200303/348 X-Sequence-Number: 12387 On Thu, 13 Mar 2003, Christopher Smith wrote: > I am trying to insert a date into a table with type date. > CREATE TABLE member_billing_info ( > userid varchar(30) primary key, > creditcard_type varchar(30), > creditcard_number varchar(50), > ****exp_date date, > first_name varchar(100), > last_name varchar(100), > street_address varchar(100), > city varchar(100), > state varchar(30), > zip_code varchar(30), > country varchar(100), > phone_number varchar(30), > email varchar(200), > date_entered timestamp, > last_update_time timestamp > ); > CREATE or replace FUNCTION enrollpayee (character varying, integer,character varying, character varying, > text,character varying,character varying,character varying, > character varying,character varying,character varying,character varying, > character varying,character varying) RETURNS integer > AS 'DECLARE > > INSERT INTO member_billing_info > values(strUserId,intPlanId,strCardType,cryptCreditCard,v_ExpDate, > strFirstName,strLastName,strAddress,strCity,strState, > strZipCode,strCountry,strPhone,strEmail,now(),now()); > Umm, it seems to me that your insert is off on columns. You're inserting varchar, int, varchar, varchar, date, ... into a table of varchar, varchar, varchar, date I don't see an int anywhere in the table, so I'm not sure what you were intending to do.