Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Empty arrays with ARRAY[]

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: Brendan Jurd <direvus(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Empty arrays with ARRAY[]
Date: 2007-11-29 21:11:55
Message-ID: 18848.1196370715@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
>> 1) How should we determine whether the array is multidimensional if we
>> know the type in advance?

> Well, given the array should be regular you should be able to just look
> at the first element, if it's a array  look at it's first element, etc
> to determine the dimensions. This'll be fairly quick.

How does that work with non-constant array constructor members?

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2007-11-29 21:15:04
Subject: Re: pgwin32_open returning EINVAL
Previous:From: Tom LaneDate: 2007-11-29 20:59:44
Subject: Re: pgwin32_open returning EINVAL

pgsql-patches by date

Next:From: Kris JurkaDate: 2007-11-29 22:02:11
Subject: Re: Re: [HACKERS] [GENERAL] plperl and regexps with accented characters - incompatible?
Previous:From: Gregory StarkDate: 2007-11-29 20:22:55
Subject: Re: [DOCS] Partition: use triggers instead of rules

pgsql-general by date

Next:From: Oliver KohllDate: 2007-11-29 21:33:38
Subject: Re: hibernate + postgresql ?
Previous:From: Jennifer SpencerDate: 2007-11-29 21:08:21
Subject: Postgres WarmStandby using ZFS or Snapshot to create Web DB?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group