| From: | Tomasz Myrta <jasiek(at)klaster(dot)net> |
|---|---|
| To: | shyamperi(at)davlin(dot)co(dot)in |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Error with functions |
| Date: | 2003-09-20 06:58:56 |
| Message-ID: | 3F6BFAB0.2010106@klaster.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
> Hey,
> create or replace function sample(varchar,int) returns varchar as'
> declare
> data alias for $1;
> size alias for $2;
> begin
> return substr(data,(length(data)-size)+1,length(data));
> end;
> ' language 'plpgsql';
> ____________________________
> WARNING: plpgsql: ERROR during compile of sample near line 2
> ERROR: parse error at or near ";"
>
> Can any body tell me why is this error coming
Really?
I got no error and select sample('nothing',3) gave mi 'ing'
What is your postgresql version?
Regards,
Tomasz Myrta
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel Chabanne | 2003-09-20 07:29:24 | Re: Error with functions |
| Previous Message | shyamperi | 2003-09-20 06:24:34 | Error with functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shyamperi | 2003-09-20 07:00:42 | Re: Error with functions |
| Previous Message | shyamperi | 2003-09-20 06:24:34 | Error with functions |