On 21 February 2013 10:30, Tom Lane <[email protected]> wrote:
> Shigeru Hanada <[email protected]> writes:
>> [ postgres_fdw.v5.patch ]
>
> Applied with a lot of revisions.
Bit of an issue with selecting rows:
postgres=# SELECT * FROM animals;
id | animal_name | animal_type | lifespan
----+-------------+-------------+----------
1 | cat | mammal | 20
2 | dog | mammal | 12
3 | robin | bird | 12
4 | dolphin | mammal | 30
5 | gecko | reptile | 18
6 | human | mammal | 85
7 | elephant | mammal | 70
8 | tortoise | reptile | 150
(8 rows)
postgres=# SELECT animals FROM animals;
animals
---------
(,,,)
(,,,)
(,,,)
(,,,)
(,,,)
(,,,)
(,,,)
(,,,)
(8 rows)
postgres=# SELECT animals, animal_name FROM animals;
animals | animal_name
---------------+-------------
(,cat,,) | cat
(,dog,,) | dog
(,robin,,) | robin
(,dolphin,,) | dolphin
(,gecko,,) | gecko
(,human,,) | human
(,elephant,,) | elephant
(,tortoise,,) | tortoise
(8 rows)
postgres=# EXPLAIN (ANALYSE, VERBOSE) SELECT animals FROM animals;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------
Foreign Scan on public.animals (cost=100.00..100.24 rows=8 width=45)
(actual time=0.253..0.255 rows=8 loops=1)
Output: animals.*
Remote SQL: SELECT NULL, NULL, NULL, NULL FROM public.animals
Total runtime: 0.465 ms
(4 rows)
--
Thom
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
