Skip site navigation (1) Skip section navigation (2)

Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Eric Ridge <eebbrr(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Date: 2011-10-30 04:53:55
Message-ID: 4EACD863.1080604@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On 10/29/2011 03:26 PM, Eric Ridge wrote:
>
> Would y'all accept a patch that extended the "SELECT *" syntax to let
> you list fields to exclude from the A_Star?
>
> Quite regularly I'll be testing queries via psql and want to see all
> the columns from a fairly wide table except maybe a giant text or xml
> column.  A syntax like:
>
>       SELECT * EXCLUDING (big_col1, big_col2) FROM foo;
>

If it is quite regular I would actually argue two things:

1. Use a view
2. You haven't normalized correctly

I am not trying to be a pedantic zealot or anything but those would be 
my arguments against.

Sincerely,

Joshua D. Drake
-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579

In response to

Responses

pgsql-hackers by date

Next:From: Darren DuncanDate: 2011-10-30 08:10:13
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?
Previous:From: Pavel StehuleDate: 2011-10-30 03:37:49
Subject: Re: Thoughts on "SELECT * EXCLUDING (...) FROM ..."?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group