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 a_fu
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 broadcast)
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;
Cl
"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
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 assi
"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 th
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) de
