| From: | Kevin Heflin <kheflin(at)shreve(dot)net> |
|---|---|
| To: | "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | need help separating a field |
| Date: | 1999-02-11 20:46:19 |
| Message-ID: | Pine.LNX.4.02.9902111425100.27652-100000@mercury.shreve.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a table with a field of 'username_password' where the data is in
the format of:
username/password
what I would really like to do, is create a new field of 'username' and
another of 'password' and with some magic SQL statement select all from
username_password, and spit up the pair, and insert them back into the
newly created 'username' and 'password' fields.
Is this even possible? and if so, would anyone be willing to give me a
hint?
Kevin
--------------------------------------------------------------------
Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103
VP/Mac Tech | 333 Texas St #619 | FAX:318.221.6612
kheflin(at)shreve(dot)net | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ross J. Reedstrom | 1999-02-11 21:05:21 | Re: [GENERAL] need help separating a field |
| Previous Message | Paulo da Silva | 1999-02-11 19:06:43 | Conditioned access to a database |