> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
