Re: Stored procedure doesn't return expected result.

On 2/26/06, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> wrote:
> 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';
> ^ ^
>
> remove the '
>
> test=# select * from foo1;
> x | i
> ---+---
> a | 1
> b | 2
> (2 rows)
>
> test=# create or replace function get_i(varchar) returns int as $$
> select i from foo1 where x = $1;$$ language sql;
> CREATE FUNCTION
> test=# select get_i('a');
> get_i
> -------
> 1
> (1 row)

That's got it. Obviously it understands that $1 is a string and not a
column name.

Thanks very much.

--
-S
http://www.makepovertyhistory.org/