Sent with ProtonMail Secure Email.
‐‐‐ Original Message ‐‐‐
On Saturday, 29 May 2021 17:55, Tom Lane wrote:
> Michael Nolan htf...@gmail.com writes:
>
> > You probably need some kind order by case when else end clause,
> > where the else clause deals with the non-VIPs, prob
Michael Nolan writes:
> You probably need some kind order by case when else end clause,
> where the else clause deals with the non-VIPs, probably negating the need
> for a nulls last clause.
The idiomatic way to do this, assuming that you create an "is_vip bool"
field or some other way
On Sat, May 29, 2021 at 9:15 AM Laura Smith <
n5d9xq3ti233xiyif...@protonmail.ch> wrote:
> Hi
>
> I've got a bit of a puzzle that I'm not quite sure how to approach.
>
> Let's say I've got a table of bios, so :
>
> create table bios (
> first_name text not null,
> last_name text not null,
> person
On 5/29/21 9:34 AM, Laura Smith wrote:
‐‐‐ Original Message ‐‐‐
On Saturday, 29 May 2021 17:06, Adrian Klaver wrote:
On 5/29/21 9:00 AM, Laura Smith wrote:
I did try "nulls last" but will give it another go, maybe I messed up on the
ordering of clauses.
Unless the fields you are
‐‐‐ Original Message ‐‐‐
On Saturday, 29 May 2021 17:06, Adrian Klaver wrote:
> On 5/29/21 9:00 AM, Laura Smith wrote:
>
> > I did try "nulls last" but will give it another go, maybe I messed up on
> > the ordering of clauses.
>
> Unless the fields you are ordering on contain NULLs I'm
On 5/29/21 9:00 AM, Laura Smith wrote:
I did try "nulls last" but will give it another go, maybe I messed up on the
ordering of clauses.
Unless the fields you are ordering on contain NULLs I'm not sure how
this is going to deal with your issue.
Sent with ProtonMail Secure Email.
‐‐‐
I did try "nulls last" but will give it another go, maybe I messed up on the
ordering of clauses.
Sent with ProtonMail Secure Email.
‐‐‐ Original Message ‐‐‐
On Saturday, 29 May 2021 15:23, Michael van der Kolff
wrote:
> Have you considered use of the "nulls last" option in order by
Have you considered use of the "nulls last" option in order by (
https://www.postgresql.org/docs/13/queries-order.html)?
Alternatively, you could write your own type, with its own ordering
primitive 😉
On Sun, 30 May 2021, 12:15 am Laura Smith, <
n5d9xq3ti233xiyif...@protonmail.ch> wrote:
> Hi
>
On Saturday, May 29, 2021, Laura Smith
wrote:
>
> The problem is that my use-case calls for a scenario where due to protocol
> certain people may be designated as "VIP" and therefore need to appear at
> the top. In addition, protocol may dictate that those "VIP" people
> themselves may (sometime
