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

Inv(Image i)

Inverts the pixel values of the given image

Code Block
languagesql
titleExample
SELECT inverseinv(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>|<Matrix matrix>)

Creates a new image with the given width and height

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

ToMatrix(Image i)

Return the pixel values of the given image as a matrix

 

 

Table of Contents