Re: [GENERAL] Playing with 9.4devel - unnest

2014-03-10 Thread bricklen
On Mon, Mar 10, 2014 at 10:16 AM, Tim Kane wrote: > But what I really wanted to do, is unnest multiple sets of array values as > returned from a table/query.. > Craig Ringer posted an interesting answer to a somewhat related question a few months ago on Stack Overflow: http://stackoverflow.com/a

Re: [GENERAL] Playing with 9.4devel - unnest

2014-03-10 Thread Tim Kane
^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Any suggestions? Or should the parser be allowing a subquery as a parameter to unnest? Tim From: Tim Kane Date: Monday, 10 March 2014 15:26 To: Tom Lane Cc: pgsql-general

Re: [GENERAL] Playing with 9.4devel - unnest

2014-03-10 Thread Tim Kane
ction signature to change. Thanks for setting me straight. Tim From: Tom Lane Date: Monday, 10 March 2014 15:10 To: Tim Kane Cc: pgsql-general General Subject: Re: [GENERAL] Playing with 9.4devel - unnest Tim Kane writes: > I decided to have a play with postgresql-9.4devel as I wanted to

Re: [GENERAL] Playing with 9.4devel - unnest

2014-03-10 Thread Tom Lane
Tim Kane writes: > I decided to have a play with postgresql-9.4devel as I wanted to explore the > functionality provided by > unnest (anyarray, anyarray [, …]) > I’ve taken the nightly snpahost, compiled, installed.. All good. (Obtained > from http://ftp.postgresql.org/pub/snapshot/dev/ ) > H

[GENERAL] Playing with 9.4devel - unnest

2014-03-10 Thread Tim Kane
Hi all, I decided to have a play with postgresql-9.4devel as I wanted to explore the functionality provided by unnest (anyarray, anyarray [, …]) I’ve taken the nightly snpahost, compiled, installed.. All good. (Obtained from http://ftp.postgresql.org/pub/snapshot/dev/ ) However it seems the ex