PostgreSQL and the SQL standards process [LWN.net]

PostgreSQL and the SQL standards process

Posted Oct 5, 2011 10:52 UTC (Wed) by Jannes (subscriber, #80396)
In reply to: PostgreSQL and the SQL standards process by Baylink
Parent article: PostgreSQL and the SQL standards process

Not sure what you're getting at actually. Why use a function at all, does the GETDATE have any use?

Why not use constants .... AND 0 < 78238923123 (your random tag) ?

And while you're at it, why not just make it a comment? I've used that before to make queries easily identifiable in SHOW PROCESSLIST: (in MySQL)

/* YourTag Function Name blabla */ SELECT * FROM blabla;

The comment has the extra advantage of not affecting the query cache at all (at least in MySQL).

(Log in to post comments)