[GENERAL] Sequence question.

2003-12-16 Thread Anthony Best
I'm working on an idea that uses sequences. I'm going to create a table like this: id serial, sequence int, keyword varchar(32), text text for every keyword there will be a uniq sequence for it eg: id, sequence, keyword 1, 1, foo, ver1 2, 1, bar, bar ver1 3, 2, foo, ver2 4, 2, bar, bar ver2 etc.

Re: [GENERAL] Anomaly with SUM().

2003-08-09 Thread Anthony Best
Stephan Szabo wrote: On Fri, 8 Aug 2003, Anthony Best wrote: I've noticed that the SUM() seems to overflow under some situations. The only difference is the order that the data is retrived from the database. Is amount a float type column (float4 or float8)? If so, you're pro