Sha256: 9924c137a2440e05f8f6f03826fe18fa3ff449aa14faa7436cf9ff043c48597e
Contents?: true
Size: 1.56 KB
Versions: 2
Compression:
Stored size: 1.56 KB
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 integer, decimal_field decimal(2,1), numeric_field numeric(30,6)); --- 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); --- create table array_test (foo integer[], bar integer[3], baz integer[3][3], quux varchar[2]); --- create table bytea_test (foo bytea); --- create schema schema1; --- create schema schema2; --- create table schema1.tbl (foo integer); --- create table schema2.tbl (bar integer); --- create or replace function select_subproperty(value names.age%TYPE, sub names.age%TYPE, out retval names.age%TYPE) as $$ select case when $2 is not null then $1 else null end $$ language sql;
Version data entries
2 entries across 2 versions & 1 rubygems
Version | Path |
---|---|
dbd-pg-0.3.5 | test/dbd/postgresql/up.sql |
dbd-pg-0.3.6 | test/dbd/postgresql/up.sql |