| From: | Jie Liang <jliang(at)jliang(dot)ipinc(dot)com> |
|---|---|
| To: | guard <guard(at)ficnet(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: plpgsql ? |
| Date: | 2000-12-21 00:18:01 |
| Message-ID: | Pine.BSF.4.21.0012201601590.45028-100000@jliang.ipinc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi, there,
see following.
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang(at)ipinc(dot)com
www.ipinc.com
On Wed, 20 Dec 2000, guard wrote:
> Hi all,
>
> i have a question 'plpgsql'
>
> my code
>
> CREATE FUNCTION autono (text,text) RETURNS text AS '
> DECLARE
> a1 ALIAS FOR $1;
> a2 ALIAS FOR $1; <== $2 ??
> ret_val text;
> BEGIN
> select tna into ret_val from a1 where pamt_no=a2;
> -- I think that table name cannot use parameter anyway in plpgsql.
> RETURN ret_val;
> END;' LANGUAGE 'plpgsql'
>
>
> error run " select tna into ret_val from a1 where pamt_no=a2; "
> help me ,thanks
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jie Liang | 2000-12-21 00:22:39 | Re: `~' operator and indices |
| Previous Message | Jie Liang | 2000-12-21 00:00:15 | Re: How to set autocommit on/off |