[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Create Table Question...
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2011-01-31 16:55:39
Message-ID: 18338.1296492939 () sss ! pgh ! pa ! us
[Download RAW message or body]

Jerry LeVan <jerry.levan@gmail.com> writes:
> Here is a fragment of sql that I frequently use:
> *************
> insert into checks (select *
>    from dblink('select * from checks where date >=''1/1/2011''')
>    as (date date,
>        amount numeric(9,2),
>         tranid text,
>        source text,
>        memo text,
>        status text,
>        category text
>       ) );
> **************
> The stuff after the 'as' is a description of the
> rows of the table checks.

> Could I shortened the above by using the automatically created row type of
> the table checks?

Unfortunately not.  It's not an unreasonable suggestion, though I'm not
sure how we'd fit it into the syntax.  Maybe we could allow casting
to resolve the output type of the function, a la

	select ... from dblink('query')::checks

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]