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

Re: [GENERAL] Empty arrays with ARRAY[]

From: "Brendan Jurd" <direvus(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Empty arrays with ARRAY[]
Date: 2007-11-27 15:52:17
Message-ID: 37ed240d0711270752g50218526u5ae1db2c8395782e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-patches
So far I've only considered the '::' cast syntax suggested in the
original proposal, e.g.:

ARRAY[]::text[]

I wonder whether we are also interested in catching CAST(), e.g.:

CAST(ARRAY[] AS text[])

I'm personally okay with leaving it at support for '::', but
admittedly I am heavily biased towards this syntax (I find CAST very
ugly).  I suppose supporting CAST as well would be the more
predictable behaviour; I think people might be surprised if we
supported one form of casting but not the other.

Comments?

Regards,
BJ

In response to

Responses

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2007-11-27 15:52:40
Subject: Re: PG 8.3beta3 Segmentation Fault during Database Restore
Previous:From: Hubert FONGARNANDDate: 2007-11-27 15:41:07
Subject: Re: PostGreSQL and recursive queries...

pgsql-patches by date

Next:From: Tom LaneDate: 2007-11-27 15:56:01
Subject: Re: [GENERAL] Empty arrays with ARRAY[]
Previous:From: Greg Sabino MullaneDate: 2007-11-27 14:55:50
Subject: Re: Proposed patch for operator lookup caching

pgsql-general by date

Next:From: Tom LaneDate: 2007-11-27 15:56:01
Subject: Re: [GENERAL] Empty arrays with ARRAY[]
Previous:From: Tom LaneDate: 2007-11-27 15:52:10
Subject: Re: autovacuum process blocks without reporting a deadlock

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