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.sample.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 |