NOTNULL in Postgres

Software

Did you know you could do this? It was news to me!

-- Usually written as: 
SELECT * FROM tablesalt WHERE greekcolumn IS NOT NULL;   
    
-- But you can also:
SELECT * FROM tablesalt WHERE greekcolumn NOTNULL;

Thanks to Kaarel Moppell for his excellent page of tips.

Author bio and support

Me!

Ruben Schade is a technical writer and infrastructure architect in Sydney, Australia who refers to himself in the third person in bios. Hi!

The site is powered by Hugo, FreeBSD, and OpenZFS on OrionVM, everyone’s favourite bespoke cloud infrastructure provider.

If you found this post helpful or entertaining, you can shout me a coffee or send a comment. Thanks ☺️.