Re: Error with functions
От
Tomasz Myrta
Тема
Re: Error with functions
Дата
Msg-id
3F6BFAB0.2010106@klaster.net
Ответ на
Error with functions (shyamperi@davlin.co.in)
Список
Дерево обсуждения
Re: Error with functions shyamperi@davlin.co.in
Re: [ADMIN] Error with functions Tom Lane <tgl@sss.pgh.pa.us>
> 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
В списке pgsql-sql по дате отправления
