Re: [SQL] error on line 1 trying to execute a script using psql

2010-06-21 Thread A. Kretschmer
In response to Tim Landscheidt : > Steven Dahlin wrote: > > > I am attempting to generate a temporary function to execute some dml with > > the following script: > > > create or replace function setuplicense() returns integer as $$ > > declare > > hwcustid integer := 0; > > retvalintege

Re: [SQL] error on line 1 trying to execute a script using psql

2010-06-21 Thread Tim Landscheidt
Steven Dahlin wrote: > I am attempting to generate a temporary function to execute some dml with > the following script: > create or replace function setuplicense() returns integer as $$ > declare > hwcustid integer := 0; > retvalinteger := 0; > begin > insert into license.customer >

[SQL] error on line 1 trying to execute a script using psql

2010-06-21 Thread Steven Dahlin
I am attempting to generate a temporary function to execute some dml with the following script: create or replace function setuplicense() returns integer as $$ declare hwcustid integer := 0; retvalinteger := 0; begin insert into license.customer ( customer_id ) values ( hwcustid );