Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

To use these functions, the Image Feature is required.

Fill(Image i, Number c)

 Fills the image with the given color

Code Block
languagesql
titleExample
SELECT fill(image, 0.5) FROM Stream


Inverse(Image i)

Inverts the pixel values of the given image

Code Block
languagesql
titleExample
SELECT inverse(image) FROM Stream

 

Get(Image i, Number x, Number y)

Return the value of the pixel at the given location

Code Block
languagesql
titleExample
SELECT get(image, 100, 100) FROM Stream

 

Set(Image i, Number x, Number y, Number c)

Set the pixel at the given location to the given value

Code Block
languagesql
titleExample
SELECT set(image, 100, 100, 0.5) FROM Stream

 

Rotate(Image i, Number angle)

Rotates the image at the given angle in degree.

Code Block
languagesql
titleExample
SELECT rotate(image, 90.0) FROM Stream

 

Resize(Image i, Number width, Number height)

Resize the image to the given width and height

Code Block
languagesql
titleExample
SELECT resize(image, 500, 500) FROM Stream

 

Sub(Image i, Number x, Number y, Number width, Number height)

Returns a sub image at the given location and the given width and height.

Code Block
languagesql
titleExample
SELECT sub(image, 5, 5, 200, 200) FROM Stream

 

ToImage(Number width, Number height)

Creates a new image with the given width and height

Code Block
languagesql
titleExample
SELECT toImage(500, 500) FROM Stream

Table of Contents