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

plpgsql ?

From: "guard" <guard(at)ficnet(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: plpgsql ?
Date: 2000-12-20 03:40:29
Message-ID: 91p999$umc$1@news.tht.net (view raw or flat)
Thread:
Lists: pgsql-sql
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;
    ret_val text;
  BEGIN
    select tna  into ret_val from a1  where pamt_no=a2;

  RETURN ret_val;
END;' LANGUAGE 'plpgsql'


error run  "   select tna  into ret_val from a1  where pamt_no=a2;    "
help me ,thanks






Responses

pgsql-sql by date

Next:From: KevinDate: 2000-12-20 04:31:14
Subject: How to set autocommit on/off
Previous:From: Jie LiangDate: 2000-12-19 22:12:09
Subject: Re: substring ..

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