Postgres doesn't seem to allow me to use a column alias as an identifier in a WHERE clause, but this is so inconvenient I feel I must be doing something wrong.<BR><BR ...

Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...