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
"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
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:
> 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
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
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.
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)
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
