Consider this select statement:
SELECT *,
1 AS query_id
FROM players
WHERE username='foobar';
It returns the column query_id
with value 1
along with a player's other columns.
How would one make the above SQL return at least the query_id
of 1
even if the select finds no rows that match?
BTW, it's PostgreSQL 8.4.