URL datatype

URL datatype mk Wed, 02/26/2014 - 15:14

The related URL data type is a subdomain over character strings and represent valid Uniform Resource Locators.

Usage example:

   CREATE TABLE URL_example (c1 URL, c2 URL(512) NOT NULL);


You can use cast() or convert() functions to convert a valid url string to a url type.

   select cast('https://www.monetdb.org/Doc/Example.html' as url);
   select convert('https://www.monetdb.org/Doc/Example.html', url);

You can also use the url prefix:

   select url 'https://www.monetdb.org/Doc/Example.html';


A collection of URL specific functions are provided to create, validate and extract portions.