From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | David Fetter <david(at)fetter(dot)org> |
Cc: | Matt Doughty <matt(dot)doughty(at)geograma(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Select all fields except one |
Date: | 2007-11-28 18:22:52 |
Message-ID: | 20071128102252.6d34b1cc@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Wed, 28 Nov 2007 10:14:52 -0800
David Fetter <david(at)fetter(dot)org> wrote:
> > > This sounds like self-modifying code. I'd submit that you're
> > > trying to do the wrong thing in the first place, and that you
> > > should look over your design for flaws like this and re-do that
> > > design.
> >
> > Or to actually try to be helpful, you could consider using a server
> > side function instead:
> >
> > select * from global_query({},TEXT);
>
> Helping somebody shoot themselves in the foot isn't helping them.
You have zero idea of his business requirements. He "may" have a valid
reason for this. I will grant that in this particular case it is
unlikely and that he is probably over thinking the automation of his
solution but still...
I would note that I use self modifying code all the time with
partitioning and there is *nothing* wrong with that. It calls "dynamic".
Sincerely,
Joshua D. Drake
>
> Cheers,
> David.
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFHTbH8ATb/zqfZUUQRAuDqAKCOKq4xoqn3lqZfYtxcYaF+z46ZMACeJd7D
UAKcBZDhQxBu8+lBsv8ZU18=
=BJBD
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2007-11-28 18:24:59 | Re: Recheck condition |
Previous Message | Josh Harrison | 2007-11-28 18:18:56 | Recheck condition |