| From: | Ewald Geschwinde <webmaster(at)geschwinde(dot)net> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | one pl/pgsql question |
| Date: | 2002-01-19 15:20:32 |
| Message-ID: | 3C498EC0.7060706@geschwinde.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
CREATE FUNCTION cashint(int4) RETURNS text AS '
DECLARE
value ALIAS for $1;
result text;
BEGIN
result=value::text;
RETURN result;
END;
' LANGUAGE 'plpgsql';
select cashint(2);
cashint
---------
2
(1 row)
this is correct nut when I' trying to get an array as return value it
throws an error
CREATE FUNCTION cashint(int4) RETURNS text[] AS '
DECLARE
value ALIAS for $1;
result text[];
BEGIN
result[1]=value::text;
RETURN result;
END;
' LANGUAGE 'plpgsql';
select cashint(2);
NOTICE: plpgsql: ERROR during compile of cashint near line 5
ERROR: parse error at or near "["
Is an array in this use not supported or am I totally wrong?
Ewald
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-19 17:41:30 | Re: one pl/pgsql question |
| Previous Message | mlw | 2002-01-19 14:02:43 | Re: [NOVICE] Functions in C with Ornate Data Structures |