I just want to bring up a point for discussion:
for the function definition is treated as a long string right now. Why
not add an additional token so that we don't have to write 10 single quotes.
for example
create function a_func() return integer as
.
end a_func
after as and before end
for example
create function a_func() return integer as
.
end a_func
after as and before end a_func marks the definition body. Would this be
better than the ' '?
I guess having a parser that gave better error messages would be nice,
too.
Yasir
---(end of
Kemin Zhou [EMAIL PROTECTED] writes:
I just want to bring up a point for discussion:
for the function definition is treated as a long string right now. Why
not add an additional token so that we don't have to write 10 single quotes.
Something's already been done about this for 8.0.
Sorry for the delay, here is the function.
Chris
--
CREATE OR REPLACE FUNCTION public.clmhdr_grid_query (varchar, varchar,
varchar, varchar, varchar, varchar) RETURNS SETOF public.clmhdr AS'
Declare
Last_Name varchar;
First_Name varchar;
Patient_Control_Number varchar;
CHRIS HOOVER [EMAIL PROTECTED] writes:
Sorry for the delay, here is the function.
CREATE OR REPLACE FUNCTION public.clmhdr_grid_query (varchar, varchar,
varchar, varchar, varchar, varchar) RETURNS SETOF public.clmhdr AS'
...
SQL_Str := select * from clmhdr;
If those are really double
tom,
They were a double quote. I switched all of the double quotes out for single
quotes but still not go. The function appears to run and return no results
but, I don't get any raises. I have even tried moving the raises to be fire
first lines in the function, but to no avail.
That first
CHRIS HOOVER [EMAIL PROTECTED] writes:
They were a double quote. I switched all of the double quotes out for single
quotes but still not go. The function appears to run and return no results
but, I don't get any raises. I have even tried moving the raises to be fire
first lines in the
Hello all,
yes, I know, row number isn't a concept that fits into the
relational model and I will only be asking for something
similar.
explanation (actual views below)
I have a view that holds the vaccinations scheduled for a
patient (v_vaccs_scheduled4pat)