DESCRIPTION

SQL support for GRASS.

Supported is a limited set of SQL functions and operators.

FUNCTIONS

  ALTER TABLE table ADD [COLUMN] columndef
  CREATE TABLE table ( columndefs )
  DROP TABLE table
  SELECT columns FROM table
  SELECT columns FROM table WHERE condition
  DELETE FROM table
  DELETE FROM table WHERE condition
  INSERT INTO table values
  INSERT INTO table ( columns ) values
  UPDATE table SET assignments
  UPDATE table SET assignments WHERE condition

OPERATORS

  "="  : equal
  "<"  : smaller than
  "<=" : smaller/equal than
  ">"  : larger than
  ">=" : larger/equal than
  "<>" : not equal
  "~"  : Substring matching

NOTES

Last changed: $Date: 2004/05/19 13:38:46 $


Help Index