Re: [SQL] sum(bool)?

2001-02-23 Thread Olaf Zanger
hi there, s cool, this works streight away and took 5 min. waiting for a answer :-) thanks very much to you tod personal and the mailing list for existence. Olaf Tod McQuillin schrieb: > > On Fri, 23 Feb 2001, Olaf Zanger wrote: > > > i'd like to add up th

[SQL] sum(bool)?

2001-02-23 Thread Olaf Zanger
hi there i'd like to add up the "true" values of a comparison like sum(a>b) it just doesn't work like this any workaround postgres 7.0 on linux thanks olaf -- soli-con Engineering Zanger Dipl.-Ing. (FH) Olaf Marc Zanger Lorrainestrasse 23 3013 Bern / Switzerland Fon: +41-31-332 9782 Mob: +

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
um, sorry, forgot to ask then this is a bug eh :-¦ ? olaf Tom Lane schrieb: > > Olaf Zanger <[EMAIL PROTECTED]> writes: > > it doesn't show ver_id_seq, nor own_id_seq when doing a \ds > > but it brings up an error "cannot create sequence) if i want

Re: [SQL] cannot create sequence

2001-02-15 Thread Olaf Zanger
hi there, good guess, they are still there. can i just delete them? olaf Tom Lane schrieb: > > Olaf Zanger <[EMAIL PROTECTED]> writes: > > it doesn't show ver_id_seq, nor own_id_seq when doing a \ds > > but it brings up an error "cannot create sequence) if

Re: [SQL] cannot create sequence

2001-02-14 Thread Olaf Zanger
hi there, trouble means: it doesn't show ver_id_seq, nor own_id_seq when doing a \ds but it brings up an error "cannot create sequence) if i want to create table ver (id serial, ...); this happend after i mistakenly did create table cng (id serial, ver_id int4 constraint ver_id_cst reference