Re: COPY IN as SELECT target

On Thu, Dec 17, 2009 at 12:28:50PM -0500, Robert Haas wrote:
> On Thu, Dec 17, 2009 at 12:23 PM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
> > How about just COPY FROM? As in
> >
> > SELECT t[5] as a, 3*(t[3]::numeric) as b FROM (COPY FROM STDIN
> > CSV) as t
> 
> I had the same thought.  Though it would also be nice to allow
> something like:
> 
> COPY (type1, type2, type3, type4) FROM STDIN CSV
> 
> ...which is obviously going to create a horrible parser problem if
> you actually tried to use that syntax.

How about using the CTE syntax?

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate