Re: [SQL] Setting boolean column based on cumulative integer value

2006-12-01 Thread Aaron Bono
On 12/1/06, Markus Juenemann <[EMAIL PROTECTED]> wrote: Hi (again!) [stupid email program sent my message before I finished it!!!] I've got a bit of a tricky (for me!) problem. The example below is completely ficticious but describes my real problem in a way which might be easier to understand

Re: [SQL] Setting boolean column based on cumulative integer value

2006-12-01 Thread Richard Broersma Jr
> CREATE TABLE passenger_queue ( > id serial NOT NULL, > name character varying(40) NOT NULL, > weight integer NOT NULL, > gets_seat boolean default false > ) > > insert into passenger_queue values (1,"Peter",75,false) > insert into passenger_queue values (2,"Mary",50,false) > insert into passenge

Re: [SQL] Setting boolean column based on cumulative integer value

2006-12-01 Thread A. Kretschmer
am Sat, dem 02.12.2006, um 0:50:37 +1100 mailte Markus Juenemann folgendes: > I've got a bit of a tricky (for me!) problem. The example below is > completely ficticious but > describes my real problem in a way which might be easier to understand. > > Imagine the table contains a list of passenge

[SQL] Setting boolean column based on cumulative integer value

2006-12-01 Thread Markus Juenemann
Hi (again!) [stupid email program sent my message before I finished it!!!] I've got a bit of a tricky (for me!) problem. The example below is completely ficticious but describes my real problem in a way which might be easier to understand. Imagine the table contains a list of passenger wanting