Re: Identifying Reason for Column Name Returned by SELECT

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Identifying Reason for Column Name Returned by SELECT
Date: 2011-09-14 17:10:16
Message-ID: CABvLTWG_HutMk5uHJkTTc2kekG-j+WrzyMnfwb7qwkRvVfbfQg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 14, 2011 at 10:04 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-09-14 17:20:31 Re: Identifying Reason for Column Name Returned by SELECT
Previous Message Rich Shepard 2011-09-14 17:04:51 Re: Identifying Reason for Column Name Returned by SELECT