etter
Sent: Wednesday, November 28, 2007 1:15 PM
To: Joshua D. Drake
Cc: Matt Doughty; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Select all fields except one
On Wed, Nov 28, 2007 at 09:47:19AM -0800, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 Nov 2007 10:14:52 -0800
David Fetter <[EMAIL PROTECTED]> 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
On Wed, Nov 28, 2007 at 09:47:19AM -0800, Joshua D. Drake wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Wed, 28 Nov 2007 09:37:43 -0800
> David Fetter <[EMAIL PROTECTED]> wrote:
>
> > On Wed, Nov 28, 2007 at 05:06:45PM +0100, Matt Doughty wrote:
> > > Hi,
> > >
> > > Is there a
On Nov 28, 2007 12:18 PM, Vivek Khera <[EMAIL PROTECTED]> wrote:
> For best practices, you should never use select * in your queries. You will
> inevitably end up with code that cannot deal with a schema change, and for
> any live system, you will have a schema change at some point...
>
> It is be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 Nov 2007 09:37:43 -0800
David Fetter <[EMAIL PROTECTED]> wrote:
> On Wed, Nov 28, 2007 at 05:06:45PM +0100, Matt Doughty wrote:
> > Hi,
> >
> > Is there a way of selecting all fields except for one in particular?
> > I'd like to create a q
On Wed, Nov 28, 2007 at 05:06:45PM +0100, Matt Doughty wrote:
> Hi,
>
> Is there a way of selecting all fields except for one in particular?
> I'd like to create a query that says something like:
>
> select * except fieldx
>
> What I'm hoping to achieve is a query that can be valid for a numbe
2007 11:07 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Select all fields except one
Hi,
Is there a way of selecting all fields except for one in particular? I'd
like to create a query that says something like:
select * except fieldx
What I'm hoping to achieve is a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/28/07 11:18, Vivek Khera wrote:
>
> On Nov 28, 2007, at 11:06 AM, Matt Doughty wrote:
>
>> Is there a way of selecting all fields except for one in particular?
>> I'd like to create a query that says something like:
>>
>> select * except fieldx
On Nov 28, 2007, at 11:06 AM, Matt Doughty wrote:
Is there a way of selecting all fields except for one in particular?
I'd like to create a query that says something like:
select * except fieldx
For best practices, you should never use select * in your queries.
You will inevitably end
Hi,
Is there a way of selecting all fields except for one in particular? I'd
like to create a query that says something like:
select * except fieldx
What I'm hoping to achieve is a query that can be valid for a number of
different tables, although the field I don't want to select is alwa
10 matches
Mail list logo
