[SQL] Unsigned numbers

2003-11-28 Thread Kaloyan Iliev Iliev
Hello Friends, I have the following questions. I have a lot of fields in my database that are int or float. The problem is that I need them to be only positive (unsigned) and the users try to insert sometimes negative. I know that I can make this with CHECK CONSTRAINT but for some reasons this i

[SQL] Unsigned numbers

2003-11-27 Thread Kaloyan Iliev Iliev
10x you all ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [SQL] Unsigned numbers

2003-11-26 Thread Richard Huxton
On Wednesday 26 November 2003 11:10, Kaloyan Iliev Iliev wrote: > Hello Friends, > > I have the following questions. > I have a lot of fields in my database that are int or float. > The problem is that I need them to be only positive (unsigned) and the > users try to insert sometimes negative. [sni

[SQL] Unsigned numbers

2003-11-26 Thread Kaloyan Iliev Iliev
Hello Friends, I have the following questions. I have a lot of fields in my database that are int or float. The problem is that I need them to be only positive (unsigned) and the users try to insert sometimes negative. I know that I can make this with CHECK CONSTRAINT but for some reasons this i