plpgsql ? - Mailing list pgsql-sql

From guard
Subject plpgsql ?
Date
Msg-id 91p999$umc$1@news.tht.net
Whole thread Raw
Responses Re: plpgsql ?  (Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>)
Re: plpgsql ?  (Jie Liang <jliang@jliang.ipinc.com>)
List 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







pgsql-sql by date:

Previous
From: "Kevin"
Date:
Subject: How to set autocommit on/off
Next
From: Artur Rataj
Date:
Subject: `~' operator and indices