Re: coalesce function

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: coalesce function
Date: 2013-06-20 22:14:19
Message-ID: CAPTjJmqOKn+7-OOJ2OUD0kNsn-N7nb+Tox1MZ0NH19oTKK8Oug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 21, 2013 at 7:36 AM, David Johnston <polobo(at)yahoo(dot)com> wrote:
> SELECT input
> FROM ( SELECT unnest($1) AS input ) src
> WHERE input IS NOT NULL AND input <> ''
> LIMIT 1;

Does this guarantee the order of the results returned? Using LIMIT
without ORDER BY is something I've learned to avoid.

ChrisA

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Long 2013-06-20 22:18:25 Easiest way to compare the results of two queries row by row and column by column
Previous Message Jason Long 2013-06-20 22:03:06 Re: Problem with left join when moving a column to another table