In article <[EMAIL PROTECTED]>,
george young writes:
> [PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
> I have a table mytable like:
> i | txt
> ---+---
> 1 | the
> 2 | the
> 3 | rain
> 4 | in
> 5 | mainly
> 6 | spain
> 7 | stays
> 8 | mainly
> 9 |
On Thu, Nov 10, 2005 at 10:58:18 -0500,
george young wrote:
> [PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
>
> I have a table mytable like:
> i | txt
> ---+---
> 1 | the
> 2 | the
> 3 | rain
> 4 | in
> 5 | mainly
> 6 | spain
> 7 | stays
> 8 | mai
[PostgreSQL 7.4RC2 on i686-pc-linux-gnu](I know, I know... must upgrade soon)
I have a table mytable like:
i | txt
---+---
1 | the
2 | the
3 | rain
4 | in
5 | mainly
6 | spain
7 | stays
8 | mainly
9 | in
I want to update it, adding a ':' to txt so that each txt value is unique.
I