Re: coalesce function - Mailing list pgsql-general

From Chris Angelico
Subject Re: coalesce function
Date
Msg-id CAPTjJmqOKn+7-OOJ2OUD0kNsn-N7nb+Tox1MZ0NH19oTKK8Oug@mail.gmail.com
Whole thread Raw
In response to Re: coalesce function  (David Johnston <polobo@yahoo.com>)
Responses Re: coalesce function  (David Johnston <polobo@yahoo.com>)
List pgsql-general
On Fri, Jun 21, 2013 at 7:36 AM, David Johnston <polobo@yahoo.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


pgsql-general by date:

Previous
From: Jason Long
Date:
Subject: Re: Problem with left join when moving a column to another table
Next
From: Jason Long
Date:
Subject: Easiest way to compare the results of two queries row by row and column by column