File: test1

package info (click to toggle)
grass 6.0.2-6
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 40,044 kB
  • ctags: 31,303
  • sloc: ansic: 321,125; tcl: 25,676; sh: 11,176; cpp: 10,098; makefile: 5,025; fortran: 1,846; yacc: 493; lex: 462; perl: 133; sed: 1
file content (36 lines) | stat: -rw-r--r-- 598 bytes parent folder | download | duplicates (3) 
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
 
X
create table grass_test1 (i1 integer, d1 double precision, c1 varchar(20))

X
insert into grass_test1 values ( 1, 123.456, 'abcd' )

X
insert into grass_test1 values ( 2, null, 'xxx' )

S
select * from grass_test1
1|123.456000|abcd
2||xxx

S
select c1 from grass_test1 where d1 < 500 / 2 and i1 <> 2  and c1 ~ 'bc' 
abcd

X
insert into grass_test1 values ( 3, 0.0, '_\''_' )

X
alter table grass_test1 add column i2 integer

X
update grass_test1 set d1 = 18.6, i2 = 987  where i1 = 2

S
select * from grass_test1
1|123.456000|abcd|
2|18.600000|xxx|987
3|0.000000|_\'_|

X
drop table grass_test1