Postgres Pro
Downloads
Home   >   mailing lists

Re: Identifying Reason for Column Name Returned by SELECT - Mailing list pgsql-general

From Richard Broersma
Subject Re: Identifying Reason for Column Name Returned by SELECT
Date
Msg-id CABvLTWG_HutMk5uHJkTTc2kekG-j+WrzyMnfwb7qwkRvVfbfQg@mail.gmail.com
Whole thread Raw
In response to Re: Identifying Reason for Column Name Returned by SELECT  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Identifying Reason for Column Name Returned by SELECT
List pgsql-general
Tree view 
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 by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Identifying Reason for Column Name Returned by SELECT
Next
From: Rich Shepard
Date:
Subject: Re: Identifying Reason for Column Name Returned by SELECT