Sha256: 7356c24a46efa99132b4302819b35d59af9abd32b6dddb3c8920bd05219941a9
Contents?: true
Size: 976 Bytes
Versions: 1
Compression:
Stored size: 976 Bytes
Contents
create table names ( name varchar(255), age integer ); --- insert into names (name, age) values ('Joe', 19); --- insert into names (name, age) values ('Jim', 30); --- insert into names (name, age) values ('Bob', 21); --- create table precision_test (text_field varchar(20) primary key not null, integer_field decimal(2,1)); --- CREATE TABLE blob_test (name VARCHAR(30), data OID); --- create view view_names as select * from names; --- create or replace function test_insert (varchar(255), integer) returns integer language sql as 'insert into names (name, age) values ($1, $2); select age from names where name = $1'; --- create table boolean_test (num integer, mybool boolean); --- create table time_test (mytime time); --- create table timestamp_test (mytimestamp timestamp); --- create table bit_test (mybit bit); --- create table field_types_test (foo integer not null primary key default 1); --- create table db_specific_types_test (foo integer);
Version data entries
1 entries across 1 versions & 1 rubygems
Version | Path |
---|---|
dbd-odbc-0.2.4 | test/dbd/odbc/up.sql |