[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] CREATE TABLE with a column of type {table name}
From: Stephan Szabo <sszabo () megazone ! bigpanda ! com>
Date: 2003-07-31 10:56:33
[Download RAW message or body]
On Thu, 31 Jul 2003, Ang Chin Han wrote:
> In Postgresql 7.3, a datatype can be int, text, etc, and also
> pseudo-types like RECORD, any, etc.
>
> These pseudo types are mainly used in CREATE FUNCTIONs, but what if it's
> used in a CREATE TABLE, esp. when the name of another table is used as a
> datatype?
[...]
>
> -- Hmmm... What if pseudo-types in CREATE TABLEs?
> -- *** THIS IS THE WHAT I'M INTERESTED IN ***
> CREATE TABLE bar(myfoo foo, c int);
>
> -- The only way I can think of to insert values into the table bar:
> SELECT INTO bar SELECT get_foo1(), 1;
You can write casts as well presumably to allow other inputs.
> -- How to retrieve data from bar?
> SELECT * FROM bar;
> ERROR: Cannot display a value of type RECORD
>
> SELECT myfoo.a FROM bar;
> ERROR: Attribute "myfoo.a" not found
However the syntax
select a(myfoo),b(myfoo) from bar
should work.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic