Input
- Output of URIUnpack Example
SQL Call
SELECT * FROM URIPack ( ON uripack_input USING Queries('p1','p2','p3') Accumulate('id') SchemeColumn('scheme') HostColumn('host') PathColumn('path') FragmentColumn('fragment') IgnoreValues('null','192.0.2.16') ) AS dt ORDER BY id;
Output
id uri -- --------------------------------------------------------------------------------------- 1 https://www.google.com/webhp?p1=chrome&p2=hello+world&p3=utf-8#fragment1 2 http://www.ietf.org/rfc/rfc2396.txt 3 ldap://[2001:db8::7]/c=gb 4 telnet:/// 5 http://www.bar.com/baz/foo?p1=netscape&p2=%7Bhello+world%7D&p3=utf#this+is+fragment+too
Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.