annotate tests/init.ur @ 1168:69f1d39d3f2d

Use COALESCE to hide NULL results of aggregate functions; fix bug with improper ordering of query result columns
author Adam Chlipala <adamc@hcoop.net>
date Thu, 25 Feb 2010 14:55:35 -0500
parents 0657e5adc938
children 8a169fc0838b
rev   line source
adamc@1073 1 sequence seq
adamc@1073 2 table fred : {A : int, B : int}
adamc@1073 3
adamc@1075 4 task initialize =
adamc@1073 5 setval seq 1;
adamc@1073 6 dml (INSERT INTO fred (A, B) VALUES (0, 1))