S-SQL Examples B

S-SQL Examples Home Page

A B C D E F G H I J K L M N O P R S T U V W Special Characters Calling Postgresql Stored Functions and Procedures

Between

  (query (:select 'name
                :from 'countries
                :where (:between 'latitude -10 10))
       :column)

("Solomon Islands" "Benin" "Brazil" "Brunei" "Cameroon" "Congo"  "Costa Rica" "Ecuador" "Ethiopia" "Gabon" "Ghana"  "Guyana" "Indonesia" "Ivory Coast" "Kenya" "Kiribati" "Liberia"  "Malaysia" "Maldives" "Marshall Islands" "Micronesia" "Nauru" "Nigeria"  "Palau" "Panama" "Papua New Guinea" "Peru" "Rwanda" "Seychelles"  "Sierra Leone" "Singapore" "None" "Sri Lanka" "Suriname" "Tanzania"  "East Timor" "Togo" "Tuvalu" "Uganda" "Venezuela" "Colombia")

Boolean Operators (:is-true, :is-false, :is-null)

:Is-True

(query (:select '* :from 'boolean-test :where (:is-true 'a)))

:Is-False

(sql (:select '* :from 'table1 :where (:is-false 'col)))

:Is-NULL

(:select '* :from 'table1 :where (:is-false 'col))