JB> Offered up because I have no explanation, and curiosity overwhelms me:
JB> I was attempting to create a table from a SELECT statement against
JB> another table:
JB> create table foo
JB> as select
JB> a,
JB> f(b)
JB> from xxx;
In this command table foo populated after the select statement
Offered up because I have no explanation, and curiosity overwhelms me:
I was attempting to create a table from a SELECT statement against
another table:
create table foo
as select
a,
f(b)
from xxx;
The function f() attempts to make a unique value based on its argument
(it's actually a "usernam
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Arash Zaryoun wrote:
| Hi All,
|
| I have a table which has 'SERIAL' datatype. When I use 'create table X
| as select * from my-table' , it creates the table but without serial
| datatype. I mean without implicit sequence.
|
| test=> \d qptuser
|
Hi All,
I have a table which has 'SERIAL' datatype. When I use 'create table X
as select * from my-table' , it creates the table but without serial
datatype. I mean without implicit sequence.
test=> \d qptuser
Table "public.qptuser"
Column | Type
