BUG #16323: CREATE TABLE AS SELECT with unknown column type

Started by PG Bug reporting formabout 6 years ago2 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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!

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: PG Bug reporting form (#1)
Re: BUG #16323: CREATE TABLE AS SELECT with unknown column type

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.