log inhelp

  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

QueryByExample

Query By Example

 

http://pgfoundry.org/projects/qbe

 

I could just steal my own flavour text from pgfoundry, but why bother?

 

Briefly: it's a PostgreSQL extension. WHERE and ORDER BY clauses that work by letting you specify a few examples by primary key value, e.g. SELECT field FROM someTable WHERE EXAMPLE KEY foo LIKE ('bar', 'baz', 'quux') NOT LIKE ('plugh', 'xyzzy').

 

WHERE works. ORDER BY doesn't, yet. With enough Red Bull, maybe tonight it will.

Printable version