[SQL] unsubscribe

unsubscribe

[SQL] unsubscribe

unsubscribe -- Susan Evans Haywood County Schools NCWISE Coordinator 216 Charles Street Clyde, NC 28721 828-627-8314 (Phone) 828-627-8277 (Fax) 216 Charles Street Clyde, NC 28721 ---(end of broadcast)--- TIP 3: Have you checked our extensive FA

[SQL] Alter Table

When i alter a table and add a new column it always adds it to the end of the table. Is there any way to tell it to add the new column at the 5th position or to add the new column after a surtain column. Thanks Shavonne Wijesinghe http://www.studioform.it

Re: [SQL] Alter Table

am Thu, dem 15.03.2007, um 14:35:41 +0100 mailte Shavonne Marietta Wijesinghe folgendes: > When i alter a table and add a new column it always adds it to the end of the > table. Is there any way to tell it to add the new column at the 5th position > or > to add the new column after a surtain col

Re: [SQL] Joins on many-to-many relations.

On 3/14/07, Wiebe Cazemier <[EMAIL PROTECTED]> wrote: I discovered that removing the subselect (the entire second condition of the join actually) is not the only thing that speeds it up. If I remove the LIKE check on account.description, it's also a lot faster (152 ms as opposed to 2915 ms), alth

Re: [SQL] Joins on many-to-many relations.

On Thursday 15 March 2007 15:05, Rodrigo De León wrote: > From http://www.postgresql.org/docs/8.2/static/indexes-types.html : > > "The optimizer can also use a B-tree index for queries involving the > pattern matching operators LIKE and ~ if the pattern is a constant and > is anchored to the begi

[SQL] join table with itself?

I am not getting to grips with the following query: set-up: Postgresql 8.1 The table HISTORY contains stockmarket data: DAY HIGHLOW 2007/02/28 6286.1 6166.2 2007/02/27 6434.7 6270.5 2007/02/26 6446.8 6401.5 I'd like to produce the following resul

Re: [SQL] join table with itself?

On 15/03/07, T E Schmitz <[EMAIL PROTECTED]> wrote:(...) Try join the tables. SELECT present.day, present.low, (MIN(future.day)-present.day) as days2fall FROM history AS present JOIN history AS future ON ( present.day < future.day AND future.low <= present.low ) GROUP BY present.day,

Re: [SQL] Alter Table

On Thu, 2007-03-15 at 08:35, Shavonne Marietta Wijesinghe wrote: > When i alter a table and add a new column it always adds it to the end > of the table. Is there any way to tell it to add the new column at the > 5th position or to add the new column after a surtain column. No, but the good news i

Re: [SQL] join table with itself?

William Leite Araújo wrote: On 15/03/07, *T E Schmitz* <[EMAIL PROTECTED] > wrote: (...) Try join the tables. SELECT present.day, present.low, (MIN(future.day)-present.day) as days2fall FROM history AS present JOIN history AS future ON ( present.day