Re: date and plpgsql error

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.