FROM Clause subquery

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.

Responses

Browse pgsql-general by date

  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