Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RES: Whatcha' wanta have?????

2 views
Skip to first unread message

Julio Cesar

unread,
Feb 19, 2004, 1:20:46 PM2/19/04
to

Obnoxio, I'm sorry but I can't agree with you, 'cause I have tables with
more than 150 columns and doing a query to retry 148 columns, or unload this
kind of table really sucks.
I actually saw many people complaining about that.

Thanks,
Julio

-----Mensagem original-----
De: owner-inf...@iiug.org [mailto:owner-inf...@iiug.org] Em
nome de Obnoxio The Clown
Enviada em: quinta-feira, 19 de fevereiro de 2004 11:21
Para: inform...@iiug.org
Assunto: RE: Whatcha' wanta have?????

Julio Cesar wrote:

> A except clause in a select * from table would be great.
>
> This would be very helpful for cases when you have a bunch of columns in a
> table and you need either to select or unload almost all of them,
> excluding 1, 2 or more columns.

That is impressively lazy.

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 6/2/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.580 / Virus Database: 367 - Release Date: 6/2/2004


sending to informix-list

Madison Pruet

unread,
Feb 19, 2004, 2:47:49 PM2/19/04
to
I suspect that the issue with this type of request is "Should this be part
of the SQL standard, or should this be part of tooling?"

M.P.


"Julio Cesar" <ju...@prodesmaq.com.br> wrote in message
news:c12vu0$25d$1...@terabinaries.xmission.com...


>
> Obnoxio, I'm sorry but I can't agree with you, 'cause I have tables with
> more than 150 columns and doing a query to retry 148 columns, or unload
this
> kind of table really sucks.
> I actually saw many people complaining about that.
>
> Thanks,
> Julio
>
> -----Mensagem original-----
> De: owner-inf...@iiug.org [mailto:owner-inf...@iiug.org] Em
> nome de Obnoxio The Clown
> Enviada em: quinta-feira, 19 de fevereiro de 2004 11:21
> Para: inform...@iiug.org
> Assunto: RE: Whatcha' wanta have?????
>
> Julio Cesar wrote:
>
> > A except clause in a select * from table would be great.
> >
> > This would be very helpful for cases when you have a bunch of columns in
a
> > table and you need either to select or unload almost all of them,
> > excluding 1, 2 or more columns.
>
> That is impressively lazy.
>
> --

> "C'est pas parce qu'on n'a rien ą dire qu'il faut fermer sa gueule"

Obnoxio The Clown

unread,
Feb 19, 2004, 5:46:33 PM2/19/04
to
Julio Cesar wrote:

> Obnoxio, I'm sorry but I can't agree with you, 'cause I have tables with
> more than 150 columns and doing a query to retry 148 columns, or unload
> this kind of table really sucks.

Interesting table design.

> I actually saw many people complaining about that.

Mostly lazy ones, is my guess. :o)

> -----Mensagem original-----
> De: owner-inf...@iiug.org [mailto:owner-inf...@iiug.org] Em
>

0 new messages