Re: [SQL] PL/pgSQL Function Problem

2004-09-11 Thread Michalis Kabrianis
the inquirer wrote: 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. Any help would be greatly appreciate

[SQL] PL/pgSQL Function Problem

2004-09-10 Thread the inquirer
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. Any help would be greatly appreciated. SELECT create_aut

Re: [SQL] PL/PGSQL Function problem.

2000-08-15 Thread Stephan Szabo
Actually, you can't do too much about it in PL/PGSQL, because IIRC there isn't a way right now to do that. I don't remember when PL/TCL came into existance (don't know TCL), but you'd be able to do it in that, and you can also do it from SPI in a C function. And finally, the obligatory upgrade

[SQL] PL/PGSQL Function problem.

2000-08-15 Thread Dirk Elmendorf
RedHat 6.2 /Postgres 6.53 I'm still very new at PL/PGSQL but I have looked thru all the documentation I could find before sending this in. I have a function that I would like to be able to apply to multiple tables without having to duplicate the code. I would like to be able to pass in the ta