On top of that... "name" is a postgreSQL internal data type --
essentially -- you need to treat it as if it is an SQL "reserved word"
Therefore::I strongly recommend that you name your table something other
than "name"... for the same reasons you wouldn't name a table "select" (the
example
Script Head wrote:
I am a newbie to the stored proc. game and this is eating my brain.
The error message is accurate but not useful...
CREATE TABLE name(first VARCHAR(32) NULL,last VARCHAR(32) NULL, extra
VARCHAR(32) NULL );
CREATE OR REPLACE FUNCTION update_name() RETURNS opaque AS '
I am a newbie to the stored proc. game and this is eating my brain.
> CREATE TABLE name(first VARCHAR(32) NULL,last VARCHAR(32) NULL, extra VARCHAR(32) NULL );
> CREATE OR REPLACE FUNCTION update_name() RETURNS opaque AS '
DECLARE
BEGIN
NEW.extra:=NEW.first;
RETURN NE
