* Marti Raudsepp (marti@juffo.org) wrote:
> Unfortunately it's far less efficient. Fields would be truncated in
> psql, so full values are still detoasted and transmitted over the
> network.
I'm thinking that we're not too worried about performance of ad-hoc
psql queries..? At least, for the queries that I'd use this for, I
wouldn't be worried about that.
The various syntax proposals do seem overly long for this, however.. I
was just wondering about something like:
select ~* blah, blah, blah FROM ...
Strikes me as pretty unlikely that making a new 'version' of * like this
is going to break anything or be broken by the SQL standard. Note- I
haven't looked at the * production or tried to do anything w/ gram.y to
support this yet, but it's a heck of a lot shorter..
Thanks,
Stephen