Hello Hendra, there is no function right(column, n-Chars), but you can use substring(column-name from offset for num_chars) in combination with char_length for getting the right-n-characters as f. e.: select substring(column from (char_length(column) - 3) for 4) from table Ludwig >Dear all, > >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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
