Peter van Dijk on Nostr: TIL Postgres has a hints system, very cute ``` postgres=# select * from x y order by ...
TIL Postgres has a hints system, very cute
```
postgres=# select * from x y order by x.a;
ERROR: invalid reference to FROM-clause entry for table "x"
LINE 1: select * from x y order by x.a;
^
HINT: Perhaps you meant to reference the table alias "y".
```
```
postgres=# select * from x y order by x.a;
ERROR: invalid reference to FROM-clause entry for table "x"
LINE 1: select * from x y order by x.a;
^
HINT: Perhaps you meant to reference the table alias "y".
```