Hi all
In looking up the substr() function I just noticed this:
(man pgbuiltin)
text ltrim(text,text) left trim characters from
text text position(text,text) extract specified substring
--->>>--------------------------cut and past error? ^^^^^^^^^^^^^^^^^^^^^ text rpad(text,int,text)
rightpad string to
specified length text rtrim(text,text) right trim characters from
text text substr(text,int[,int]) extract specified substring
--->>>--- same as this -------------------------^^^^^^^^^^^^^^^^^^^^^^ text upper(text)
converttext to upper case
Have a great day
Terry Mackintosh <terry@terrym.com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.
Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.4
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!