1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
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 type enum_test as ENUM ('one', 'two', 'three');
---
create table enum_type_test (foo enum_test);
---
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;
|
