Re: can i use an array as a table (in the from clause)

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "Coarr, Matt" <mcoarr(at)mitre(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: can i use an array as a table (in the from clause)
Date: 2007-08-13 16:08:51
Message-ID: CACEA317-6255-445D-AF0A-B376EB4591E8@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 13, 2007, at 9:25 , Coarr, Matt wrote:

> Is there some way that I can treat a two dimensional array as a table
> that can be referenced in the from clause?

I know of no way off hand, and if so, not easily. This is a pretty
clear sign that you shouldn't be using arrays in this context and
should rethink your schema.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Osvaldo Rosario Kussama 2007-08-13 16:21:08 Re: [PROPOSAL] DML value format
Previous Message Scott Marlowe 2007-08-13 15:56:59 Re: non superuser creating flat files