Re: Identifying Reason for Column Name Returned by SELECT

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Identifying Reason for Column Name Returned by SELECT
Дата
Msg-id CABvLTWG_HutMk5uHJkTTc2kekG-j+WrzyMnfwb7qwkRvVfbfQg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Identifying Reason for Column Name Returned by SELECT  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: Identifying Reason for Column Name Returned by SELECT
Список pgsql-general
Дерево обсуждения 
On Wed, Sep 14, 2011 at 10:04 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:

>  This found the appropriate rows. Now, my question is DDL-related:
>
>  What is the appropriate syntax to change 'GW-22  +' to GW-22? Can I use
> 'like' or '~' in an ALTER TABLE RENAME <column> ... statement?

I'm confused.  Do you want to UPDATE the affected records to GW-22. Or
do you want to ALTER the table to add a column constraint to prevent
malformed site_id's in the future?


--
Regards,
Richard Broersma Jr.

В списке pgsql-general по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: Re: Identifying Reason for Column Name Returned by SELECT
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: Identifying Reason for Column Name Returned by SELECT