ac senthilkumar's blog

________________________________________________________________________________________

Tuesday, July 13, 2010

Remove protocol names from url in 7.4

select
            replace('https://yahoo.co.in',
                substring('https://yahoo.co.in' from '[http|htts|www.|:|//]+'),'')


Output :
 yahoo.co.in
Posted by Senthil kumar at 7/13/2010 12:24:00 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: PostgreSQL

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Popular Posts

  • PDOException: Invalid text representation
  • Selective cell protection in Spreadsheet
  • Err: Control reached end of function without RETURN in PL/PGSQL
  • Err: Call to a member function get_cellmap() on a non-object by sfDomPDFPlugin in Symfony
  • Err: There is no unique constraint matching given keys for referenced table
  • Wordpress to Blogger migration too easy..
  • Edit pages at run time for edit or spell check without any tool
  • Add day, month and year with date field
  • Sorting of Alphanumeric Column
  • List file names with modified time stamp customized

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Search in this Blog ...

Labels

  • Linux (49)
  • Errors (44)
  • PostgreSQL (44)
  • Ubuntu (38)
  • PHP (34)
  • How to (33)
  • Java Script (15)
  • Tips (15)
  • Apache (11)
  • Regular Exp (11)
  • Drupal (9)
  • Open Office (9)
  • CSS (6)
  • Flash Builder for PHP (6)
  • Symfony (5)
  • Web (5)
  • Windows (5)
  • Eclipse (3)
  • Programming (3)
  • Advanced SQL (2)
  • Firefox (2)
  • Android (1)
  • Chrome (1)
  • HipHop (1)
  • Java (1)
  • Links (1)
  • MySQL (1)
  • Softwares (1)
  • Utilities (1)

Followers
Senplusone. Simple theme. Powered by Blogger.