Another one! :) How to convert char(1) to boolean without re-exporting tables.

From: Valerio Santinelli <tanis(at)mediacom(dot)it>
To: "pgsql-general(at)postgreSQL(dot)org" <pgsql-general(at)postgreSQL(dot)org>
Subject: Another one! :) How to convert char(1) to boolean without re-exporting tables.
Date: 1999-01-19 14:58:16
Message-ID: 36A49D88.E92C2B48@mediacom.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok. This time it's a bit more difficult ;)

I'd like to convert my char(1) stuff to boolean without having to kill
the table and re-export the original from MSAccess. I think there's a
way to do that since just creating a new table with bool instead of
char(1) won't let me insert into it the values contained in the old
table seeing they're not of the same type.

Thanks as always!! :)

Valerio Santinelli
tanis(at)mediacom(dot)it

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 1999-01-19 15:40:43 Re: [GENERAL] Another one! :) How to convert char(1) to boolean without re-exporting tables.
Previous Message Jose' Soares 1999-01-19 14:19:01 Re: [GENERAL] How to increment by hand a sequence number.