> I have simple question
> I tried following code
> 
>  select right(column, number_of_character) from table
> 
> but it didn't work, saying that pg doesn't have the
> function
> is there any way to achieve such output?
> 
> honestly I have no idea that such simple feature
> doesn't exist in postgresql
> or am I wrong? since I look at SQL Key Words table and
> it's written as
> reserved
> 
> Thank you
> Regards
> Hendra

you are right but you can use the substring function, like this 

select 'test123',substring('test123' from '...$')

this return '123'





      

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to