Re: Select all fields except one
| От | Vivek Khera |
|---|---|
| Тема | Re: Select all fields except one |
| Дата | |
| Msg-id | 03CFB7A4-A305-46F7-895C-E2F608114E6D@kcilink.com обсуждение исходный текст |
| Ответ на | Select all fields except one ("Matt Doughty" <matt.doughty@geograma.com>) |
| Ответы |
Re: Select all fields except one
Re: Select all fields except one |
| Список | pgsql-general |
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 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 best to explicitly list the field names your code is expecting. Besides, I don't think you can do what you want to do with just SQL.
В списке pgsql-general по дате отправления: