Results 1 to 1 of 1
  1. #1
    Join Date
    May 2006
    Posts
    14

    Unanswered: Function error..

    Hi,

    I am tryin to create a stored procedure that will insert values into a table. It inserts an entire row into the table, with some values specified as function parameters, while some values need to be retreived from another table.
    I get the following error:
    HINT: You will need to rewrite or cast the expression.
    CONTEXT: SQL statement "insert into userinformation values ( $1 , $2 , $3 , $4 , $5 , $6 , $7 , $8 , $9 , $10 , $11 , $12 , $13 , $14 , $15 , $16 , $17 , $18 , $19 , $20 )"
    PL/pgSQL function "registertowebsite" line 64 at SQL statement

    Nvrmind... the error ws due to a type mismatch in insert clause..
    Last edited by Mukima; 05-13-06 at 20:02.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •