Re: Stored procedure doesn't return expected result.

Stuart Grimshaw <stuart(dot)grimshaw(at)gmail(dot)com> schrieb:

> I'm writing a script to clean up some data in a table, the data I'm
> using as the source is held in emails, so I've written a perl script
> to extract the info. Unfortunatly this email doesn't contain the
> client id, so I've written a stored procedure to extract it.
>
> create or replace function get_client_id(text) returns integer as $$
> SELECT intclientid FROM client WHERE vchname = '$1';
> $$ LANGUAGE SQL;
>
> However, when I do this:
>
> select get_client_id('Stuart Grimshaw');
>
> I get no results, yet:

Please read our documentation about executing dynamic commands:
http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknow)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°