FROM Clause subquery
| От | DongSoo Song |
|---|---|
| Тема | FROM Clause subquery |
| Дата | |
| Msg-id | 000c01c1c8d8$cbba7450$059e4a3d@kehc.org обсуждение исходный текст |
| Ответы |
Re: FROM Clause subquery
Re: FROM Clause subquery |
| Список | 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)
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
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)
-------------------------
test_seq
(1 rows)
Why? FROM Clause subquery not working? or my mistakes?
Help Me!
Bye.
В списке pgsql-general по дате отправления: