Skip site navigation (1) Skip section navigation (2)

Re: plpgsql ?

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 (view raw or flat)
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
> 
> 
> 
> 
> 


In response to

  • plpgsql ? at 2000-12-20 03:40:29 from guard

pgsql-sql by date

Next:From: Jie LiangDate: 2000-12-21 00:22:39
Subject: Re: `~' operator and indices
Previous:From: Jie LiangDate: 2000-12-21 00:00:15
Subject: Re: How to set autocommit on/off

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group