From: | "Stuart Grimshaw" <stuart(dot)grimshaw(at)gmail(dot)com> |
---|---|
To: | "Andreas Kretschmer" <akretschmer(at)spamfence(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stored procedure doesn't return expected result. |
Date: | 2006-02-26 13:57:04 |
Message-ID: | f916d72a0602260557l18f161c1v80e5df6fffcdc46@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Morgan Lloyd | 2006-02-26 14:32:52 | Re: psql client binary |
Previous Message | Andreas Kretschmer | 2006-02-26 13:42:08 | Re: Stored procedure doesn't return expected result. |