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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: [GENERAL] string_to_array with empty input


  • From: "David E. Wheeler" <david(at)kineticode(dot)com>
  • To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • Cc: Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: [GENERAL] string_to_array with empty input
  • Date: Mon, 30 Mar 2009 21:21:29 -0700
  • Message-id: <1E6E35DF-4260-4559-8E68-3A7775A2D324@kineticode.com> <text/plain>

On Mar 30, 2009, at 8:26 PM, Tom Lane wrote:

Does anyone want to argue for keeping it the same?  Or perhaps
argue that a zero-element array is a more sensible result than
a one-element array with one empty string?  (It doesn't seem
like it to me, but maybe somebody thinks so.)

Hrm. There seems to be some disagreement about this among some languages:

% perl -le '@r = split /-/, ""; print length @r; print qq{"$r[0]"}'
1
""

% irb
>> puts ''.split('-')
=> nil

So Perl returns a single element as Steve had been expecting, while Ruby returns nil. I'm used to the Perl way, but I guess there's room for various interpretations, including the current implementation, with which Ruby would seem to agree.

Best,

David



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group