From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Ryan Miranda <ryan(dot)miranda(at)gmail(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Invalid Input syntax for type bigint |
Date: | 2005-01-24 04:10:06 |
Message-ID: | 20050124041006.GA19843@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Sun, Jan 23, 2005 at 02:59:36PM -0800, Ryan Miranda wrote:
> I am trying to run the proc below but get an error : invalid input
> syntax for type bigint: "2004-10-26" Can anyone suggest what I am
> doing wrong here?
Apparently you're trying to use a date where a bigint is expected.
One possibility might be here:
> SELECT ix_workflow_task."DATE_COMPLETED",
> ix_workflow_task."WORKFLOW_ACTIVITY_XPDL_ID", ix_workflow_task."TYPE"
> INTO workflow_t from ix_workflow_task
You declared workflow_t to be ix_workflow_task%ROWTYPE but you're
only selecting certain fields into it. Is the first field in
ix_workflow_task perchance a bigint?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-01-24 04:58:35 | Re: OID's |
Previous Message | Mihail Nasedkin | 2005-01-24 03:57:43 | Re: OID's |