> Here's my parameterized function:
>
> CREATE OR REPLACE FUNCTION getsenators(text)
> RETURNS SETOF senators AS
> '
> DECLARE
> input ALIAS FOR $1;
> r senators%rowtype;
> BEGIN
> FOR r IN SELECT s_fname,s_lname,s_email
> FROM senate_members WHERE s_party=input LOOP
> RETURN NEXT r;
> END LOOP;
> RETURN;
> END
> '
> LANGUAGE 'plpgsql' VOLATILE;
>
> When I type SELECT * FROM getsenators('D') I get the correct
> set of records.
>
> I'm not even sure why it wasn't working before or what I did
> to fix it, but I now have working examples I can copy and use
> as templates.
Your previous select (that didn't work) had " instead if '. Unsure if that
was a typo - but the error message looks to confirm the fact that double
quotes were used.
Chris
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
