Thread: BUG #16323: CREATE TABLE AS SELECT with iso-8859-1 column type

BUG #16323: CREATE TABLE AS SELECT with iso-8859-1 column type

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      16323
Logged by:          Abd El Oihabe
Email address:      azabdou38@gmail.com
PostgreSQL version: 12.0
Operating system:   windows
Description:

hi ! i'm new is postgresql and i faced a problem w creating a such table for
example named 'tab '.
the problem is i have already create some user defined types  (ex: a,b and c
), and in my  'tab' i have column with a variable type, mean for the first
row the type of that column will be UDT a,for the second row the type of the
column will be UDT b ... etc. 
is that possible or even other way to make that column accept differnt
types?
thank you!


Re: BUG #16323: CREATE TABLE AS SELECT with iso-8859-1 column type

From
"David G. Johnston"
Date:
This list is intended for bug reports only.  Please use the -general list for general questions like this.  

On Fri, Mar 27, 2020 at 7:18 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16323
Logged by:          Abd El Oihabe
Email address:      azabdou38@gmail.com
PostgreSQL version: 12.0
Operating system:   windows
Description:       

is that possible or even other way to make that column accept differnt
types?

No.  SQL is a strongly typed language.

David J.