| From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
|---|---|
| To: | Wojciech Strza³ka <wojtek_strzalka(at)interia(dot)pl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PL/pgSQL |
| Date: | 2002-10-04 15:00:05 |
| Message-ID: | 20021004160005.G27710@quartz.newn.cam.ac.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 03, 2002 at 04:53:26PM +0200, Wojciech Strza³ka wrote:
> i've got a simple plsql function and this line is wrong:
>
> EXECUTE ''SELECT INTO lp MAX('' || column || '') AS MX FROM '' || table
> || '';'';
>
> with error message:
>
> "parse error at or near 'INTO' "
>
> it seems like it don't recognize SELECT INTO - but what's wrong?
How about
EXECUTE ''SELECT MAX('' || column || '') AS MX INTO lp FROM '' || table
?
Cheers,
Patrick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-04 15:00:24 | Re: Performing INSERT from a Trigger fired function |
| Previous Message | Tom Lane | 2002-10-04 14:57:13 | Re: Trouble compiling postgresql in hp-unix |