Re: textarray option for file FDW - Mailing list pgsql-hackers

From Tom Lane
Subject Re: textarray option for file FDW
Date
Msg-id 396.1295113469@sss.pgh.pa.us
Whole thread Raw
In response to textarray option for file FDW  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: textarray option for file FDW  (Andrew Dunstan <andrew@dunslane.net>)
Re: textarray option for file FDW  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> ... So now I'd like to add a 
> new option to it: "textarray". This option would require that the 
> foreign table have exactly one field, of type text[], and would compose 
> all the field strings read from the file for each record into the array 
> (however many there are).

Why is this a good thing?  It seems like it would accomplish little
except to defeat the SQL type system entirely.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: textarray option for file FDW
Next
From: Noah Misch
Date:
Subject: Re: patch: fix performance problems with repated decomprimation of varlena values in plpgsql