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
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
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
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