Re: [SQL] [GENERAL] PL/pgSQL Function Problem

2004-09-11 Thread Doug McNaught
the inquirer <[EMAIL PROTECTED]> writes: > ERROR: syntax error at or near "$1" at character 14 > CONTEXT: PL/pgSQL function "create_author" line 7 at > SQL statement PL/pgSQL errors are sometimes obscure. I'll try to comment on what looks wrong to me... > CREATE OR REPLACE FUNCTION create_autho

Re: [SQL] [GENERAL] PL/pgSQL Function Problem

2004-09-10 Thread Tom Lane
the inquirer <[EMAIL PROTECTED]> writes: > I am trying to create a function that creates a user > and adds a row to a table. It produces no warnings or > errors when I create the function but when I attempt > to execute it I get a syntax error. I do not > understand why this is happening. > CREA