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.