[SQL] query; check for zero and floats

2006-03-31 Thread vince
I've tried numerous things to no avail) 2. If SUM(x2 + y2) == 0; there is a divide by zero error. How do I check and pass on zeroes? Thanks, Vince. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Re: [SQL] PostgreSQL web page

2001-01-10 Thread Vince Vielhaber
tgreSQL website - these groups have their own websites for that and PostgreSQL.org doesn't need to be caught up in the middle. pgsql-sql is in the users section - both info and archives. > Beyond that, the web site is ma

Re: [SQL] problem with select where like ']'

2000-10-17 Thread Vince Vielhaber
Don't get too attached to the url below, it will be going away very soon. Vince. On Tue, 17 Oct 2000, Bruce Momjian wrote: > The fact is, I can't figure out how to get there without the URL. > > > > Joseph Shraibman <[EMAIL PROTECTED]> writes: > > > WHAT mail

[SQL] Re: [PHP-DB] Problem regarding 'select...as...'

2000-06-12 Thread Vince LaMonica
On 2000-06-12, Bernie Huang stated: } "select equip_attr[1], equip_attr[2] } as year, make } from vehicle_tb;" } } which gives me the following error: } } "ERROR: Attribute 'make' not found" } } Is there something wrong with my "as" usage? Thanks Try: "select equip_attr[1] as year,