Re: [SQL] Date Index

2012-11-05 Thread Adam Tauno Williams
On Fri, 2008-10-31 at 08:48 +0100, A. Kretschmer wrote: > am Thu, dem 30.10.2008, um 14:49:16 -0600 mailte Ryan Hansen folgendes: > > Hey all, > > I?m apparently too lazy to figure this out on my own so maybe one of you can > > just make it easy on me. J > > I want to index a timestamp field but

Re: [SQL] short-cutting if sum()>constant

2009-12-22 Thread Adam Tauno Williams
On Tue, 2009-12-22 at 13:35 +0100, Ivan Sergio Borgonovo wrote: > Hi, > I'd like to know if > select sum(qty) from t where status=37; > is > constant. > qty is always >0. > Is there a way to skip examining further rows and return a result > ASAP? SELECT SUM(object_version) FROM date_x WHERE owner_

Re: [SQL] Converting from MS Access field aliases

2007-07-12 Thread Adam Tauno Williams
On Thu, 2007-07-12 at 13:23 -0400, Tom Lane wrote: > chester c young <[EMAIL PROTECTED]> writes: > >> SELECT field1 / 2 AS foo, > >> field2 * 2 AS bar, > >> foo + bar AS total > >> WHERE foo < 12; > > First, I think it would be great if this worked - like the alias to an > > update table added in 8

Re: [SQL] Informix Schema -> PostgreSQL ?

2007-07-03 Thread Adam Tauno Williams
ace: -- CREATE UNIQUE INDEX unique_enterprise_login ON enterprise USING btree ("login"); The "--" lines just eats up screen real estate. -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - h

Re: [SQL] Informix Schema -> PostgreSQL ?

2007-07-03 Thread Adam Tauno Williams
ot;dbschema -d {database}" pg_dump -U OGo --schema-only OGo -- Adam Tauno Williams, Network & Systems Administrator Consultant - http://www.whitemiceconsulting.com Developer - http://www.opengroupware.org ---(end of broadcast)--

Re: [SQL] We all are looped on Internet: request + transport = invariant

2007-04-26 Thread Adam Tauno Williams
innovative, when they are properly motivated. > >others may require the assistance of a > J> technical specialist or a full-time programming team, but what's wrong > J> with that? > expenses of money, time, nerve to explain task to other man --