From: | "DongSoo Song" <namsanmo(at)kehc(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | FROM Clause subquery |
Date: | 2002-03-11 08:43:19 |
Message-ID: | 000c01c1c8d8$cbba7450$059e4a3d@kehc.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All
I have problems on 'from clause subquery'.
test=# create sequence test_seq;
test=# select * from test_seq
Result:
sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
test_seq | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f
(1 row)
Now I want to get sequence fields following:
test=# select * from (select relname from pg_class where relkind='S') as foo;
My Result:
relname
-------------------------
test_seq
(1 rows)
Why? FROM Clause subquery not working? or my mistakes?
Help Me!
Bye.
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2002-03-11 09:21:39 | Time to case votes for PostgreSQL in the Java Developers Journal |
Previous Message | Frank_Lupo Frank_Lupo | 2002-03-11 08:22:44 | big problem |